我的语法对吗?
我现在用VB.NET做WEB应用程序,当连接数据库时,当插入时出现问题:
strSQL = "insert into 'UserInfo'('User_Name','User_Xingming','User_Sex',"
strSQL += "'User_Birthday','User_Occupation','User_Xueli','User_Province',"
strSQL += "'User_City','User_QQ','User_Email') "
strSQL += "values('" & txtUserName.Text & " ','" & txtUserXm.Text & "','男','1983-11-11','农民','本科','北京','北京','156879','lupan@hqu.edu.cn')"
objCommand = New OleDb.OleDbCommand(strSQL, objConnection)
objCommand.ExecuteNonQuery()
请问这段语法对吗?