Error in My Add button SQL Server Management Studio And Visual Basic 2010
Posted
by
user2882523
on Stack Overflow
See other posts from Stack Overflow
or by user2882523
Published on 2013-10-18T14:13:46Z
Indexed on
2013/10/18
15:55 UTC
Read the original article
Hit count: 173
sql
|visual-studio-2010
Here is the thing i cant use insert querry in my code there is an error in my sqlcommand that says the ExecuteNonQuery() not match with the values blah blah
here is my code
Dim con As New SqlClient.SqlConnection("Server=.\SQLExpress;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\Finals.mdf;Database=Finals;Trusted_Connection=Yes;")
Dim cmd As New SqlClient.SqlCommand
cmd.Connection = con
cmd.CommandText = "Insert Into [Finals].[dbo].[Nokia] Values ('" & Unit.Text & "'),('" & Price.Text & " '),('" & Stack.Text & "'),('" & Processor.Text & "'),('" & Size.Text & "'),('" & RAM.Text & "'),('" & Internal.Text & "'),('" & ComboBox1.Text & "')"
con.Open()
cmd.ExecuteNonQuery()
con.Close()
}
the problem is the cmd.CommandText can anyone pls help me
© Stack Overflow or respective owner