Run time error on: objCommand.Exec uteNonQuery()

[Matthew Louden]

I just tried to create a simple ASP.NET application to add record to the SQL
Server database. However, it has run time error on Line 88:
objCommand.Exec uteNonQuery()

Any ideas?? Please help!! Thanks!!

Sub AddNewRecord()
Dim objConnection As SqlConnection
Dim strConnection As String = "Data Source=20.11.12 .91;Network
Library=DBMSSOC N;Initial Catalog=testtab le;User ID=sa;Password= iw;"
objConnection = New SqlConnection(s trConnection)
Dim objCommand As SqlCommand
Dim strSQLQuery As String
strSQLQuery = "INSERT INTO Test " _
& "(FirstName , LastName, SerialNumber) " _
& "VALUES (@TextValue, @TextValue, @TextValue)"
objCommand = New SqlCommand(strS QLQuery, objConnection)
objCommand.Para meters.Add(New SqlParameter("@ TextValue", SqlDbType.Char,
255))
objCommand.Para meters.Add(New SqlParameter("@ TextValue", SqlDbType.Char,
255))
objCommand.Para meters.Add(New SqlParameter("@ TextValue", SqlDbType.Char,
255))
objCommand.Para meters("@TextVa lue").Value = CStr(TextBox1.T ext)
objCommand.Para meters("@TextVa lue").Value = CStr(TextBox2.T ext)
objCommand.Para meters("@TextVa lue").Value = CStr(TextBox4.T ext)
objConnection.O pen()
objCommand.Exec uteNonQuery()
objConnection.C lose()
End Sub

Runtime error:

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: ?? ??
'@TextValue'?(? ) ?? ???????. ?? ??? ?? ?? ?? ?? ?? ???? ??? ???? ???.

Source Error:

Line 86: ' Open the connection, execute the command, and close the
connection.
Line 87: objConnection.O pen()
Line 88: objCommand.Exec uteNonQuery()
Line 89: objConnection.C lose()
Line 90:

[michael]

& "VALUES (@TextValue, @TextValue, @TextValue)"

should be:

& "VALUES ('@TextValue', '@TextValue', '@TextValue')"

notice the single-quotes

Hope this helps...

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:uP******** *****@TK2MSFTNG P10.phx.gbl...

I just tried to create a simple ASP.NET application to add record to the SQL Server database. However, it has run time error on Line 88:
objCommand.Exec uteNonQuery()

Any ideas?? Please help!! Thanks!!

Sub AddNewRecord()
Dim objConnection As SqlConnection
Dim strConnection As String = "Data Source=20.11.12 .91;Network
Library=DBMSSOC N;Initial Catalog=testtab le;User ID=sa;Password= iw;"
objConnection = New SqlConnection(s trConnection)
Dim objCommand As SqlCommand
Dim strSQLQuery As String
strSQLQuery = "INSERT INTO Test " _
& "(FirstName , LastName, SerialNumber) " _
& "VALUES (@TextValue, @TextValue, @TextValue)"
objCommand = New SqlCommand(strS QLQuery, objConnection)
objCommand.Para meters.Add(New SqlParameter("@ TextValue", SqlDbType.Char,
255))
objCommand.Para meters.Add(New SqlParameter("@ TextValue", SqlDbType.Char,
255))
objCommand.Para meters.Add(New SqlParameter("@ TextValue", SqlDbType.Char,
255))
objCommand.Para meters("@TextVa lue").Value = CStr(TextBox1.T ext)
objCommand.Para meters("@TextVa lue").Value = CStr(TextBox2.T ext)
objCommand.Para meters("@TextVa lue").Value = CStr(TextBox4.T ext)
objConnection.O pen()
objCommand.Exec uteNonQuery()
objConnection.C lose()
End Sub

Runtime error:

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: ?? ??
'@TextValue'?(? ) ?? ???????. ?? ??? ?? ?? ?? ?? ?? ???? ??? ???? ???.

Source Error:

Line 86: ' Open the connection, execute the command, and close the connection.
Line 87: objConnection.O pen()
Line 88: objCommand.Exec uteNonQuery()
Line 89: objConnection.C lose()
Line 90: