菜鸟求助!!command的ExecuteNonQuery方法的问题,运行时出错
很急呀,求各位大神指教!就是向表里插入一个元组,编译时没出错,而且也可以联通数据库,运行时标注那行出错,提示“未处理SqlException”“Values_附近有语法错误”
[code=VB.NET][/code]
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connStr, insertcommand As String
connStr = "Server=localhost;database=练习;integrated security=SSPI"
insertcommand = "Insert Into S(SNO,SNAME,STATUSS,CITY)Values_('" & GetSqlStr(txtSno.Text) & "','" & GetSqlStr(txtSname.Text) & "','" & GetSqlStr(txtStatuss.Text) & "'," & GetSqlStr(txtCity.Text) & ")"
Dim conn As SqlConnection, cmd As SqlCommand
Dim myDataSet As New DataSet()
conn = New SqlConnection(connStr)
conn.Open()
cmd = New SqlCommand(insertcommand, conn)
cmd.ExecuteNonQuery()[color=#FF0000][/color]
conn.Close()
ShowPerson()
End Sub
[解决办法]
Values_
把下划线去掉