SQL string Error in vb.net

Question

i want to connect a database to my project but i am getting an error on this line

"Data Source=.\SQLEXPRESS; AttachDbFilename="c:\users\cj\documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplication1\cj.mdf";Integrated Security=True;User Instance=True"

the error is Error 1 Character constant must contain exactly one character.
Error 2 Syntax error.

THIS IS THE CODE

Dim ms As New MemoryStream()
Me.PictureBox1.Image.Save(ms, Me.PictureBox1.Image.RawFormat)
Dim arraybuffer() As Byte = ms.GetBuffer
ms.Close()



Dim sqlString As String = "Data Source=.\SQLEXPRESS; AttachDbFilename="c:\\users\\cj\\documents\\visual studio 2010\\Projects\\WindowsApplication1\\WindowsApplication1\\cj.mdf";Integrated Security=True;User Instance=True"
Dim sqlQuery As String = "INSERT INTO image Values(@imagedata)"
Dim sqlcon As New SqlConnection(sqlString)
sqlcon.Open()
Dim sqlcmd As New SqlCommand(sqlQuery, sqlcon)
sqlcmd.Parameters.Add(New SqlParameter("@imagedata", arraybuffer))
MessageBox.Show("IMAGE SAVED IN DATABASE")
sqlcon.Close()

can you post the vb.net lines code where you get this error? — Bala R
– Bala R, Commented May 1, 2011 at 4:48
Dim sqlString As String = "Data Source=.\SQLEXPRESS; AttachDbFilename=""c:\users\cj\documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplication1\cj.mdf"";Integrated Security=True;User Instance=True" YOUR ANSWER WAS RIGHT THANX for the help — CHANDRAHAS
– CHANDRAHAS, Commented May 1, 2011 at 5:01

Bala R · Accepted Answer · 2011-05-01 05:23:26Z

2

You have to escape double quotes (") in string with double double quotes( "" ).

Try this

Dim sqlString As String = "Data Source=.\SQLEXPRESS; AttachDbFilename=""c:\users\cj\documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplication1\cj.mdf"";Integrated Security=True;User Instance=True"

answered May 1, 2011 at 5:23

Bala R

109k23 gold badges203 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL string Error in vb.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related