问题:我不能录入数剧,说我的myCommand.ExecuteNonQuery() 不能执行,说我有语法错误!
===================================================================
第 1 行: '(' 附近有语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '(' 附近有语法错误。源错误:
行 30: Dim myCommand As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand(Mysql, myConnection)
行 31: '执行插入命令
行 32: myCommand.ExecuteNonQuery()
行 33: '关闭连接
行 34: myConnection.Close()
源文件: E:\aMessage\UserReg.aspx.vb 行: 32
===========================================================
代码如下:
===================================================
Partial Class UserReg
Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' If Not Page.IsPostBack Then 'else
'Start by determining the connection string value
Dim connString As String = ConfigurationManager.ConnectionStrings("testConnectionString").ConnectionString
'创建一个SqlConnection实例
Using myConnection As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(connString)
myConnection.Open() Dim Mysql As String
'获取前面表单的值
Dim myName As String = Name.Text
Dim myPwd As String = Password.Text
Dim myAge As String = Age.Text
Dim mySex As String = Sex.SelectedValue
Dim myTel As String = Tel.Text
Dim myEmail As String = Email.Text
Dim myAdd As String = Add.Text
Dim myQuestion As String = Question.SelectedValue
Dim myAnswer As String = Answer.Text
'指定SQL语句
Mysql = "Insert into(Name_Name,Name,Pwd,Name_Age,Name_Sex,Name_Question,Name_Answer,Name_Add,Name_tel,Name_Email)"
Mysql += "values('" + myName + "','" + myPwd + "','" + myAge + "','" + mySex + "','" + myQuestion + "','" + myAnswer + "','" + myAdd + "','" + myTel + "','" + myEmail + "')"
'创建一个SqlCommand实例
Dim myCommand As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand(Mysql, myConnection)
'执行插入命令
'myCommand.ExecuteNonQuery()
'关闭连接
myConnection.Close()
End Using
Response.Write("<script language=javascript>alert('成功注册')</script>")
Response.End()
' End If End Sub
End Class
==============================================================
这是VS2005(VB)的写法,整不懂了!!请各位大侠指教一下!!!谢谢了!==============================================================
===================================================================
第 1 行: '(' 附近有语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '(' 附近有语法错误。源错误:
行 30: Dim myCommand As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand(Mysql, myConnection)
行 31: '执行插入命令
行 32: myCommand.ExecuteNonQuery()
行 33: '关闭连接
行 34: myConnection.Close()
源文件: E:\aMessage\UserReg.aspx.vb 行: 32
===========================================================
代码如下:
===================================================
Partial Class UserReg
Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' If Not Page.IsPostBack Then 'else
'Start by determining the connection string value
Dim connString As String = ConfigurationManager.ConnectionStrings("testConnectionString").ConnectionString
'创建一个SqlConnection实例
Using myConnection As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(connString)
myConnection.Open() Dim Mysql As String
'获取前面表单的值
Dim myName As String = Name.Text
Dim myPwd As String = Password.Text
Dim myAge As String = Age.Text
Dim mySex As String = Sex.SelectedValue
Dim myTel As String = Tel.Text
Dim myEmail As String = Email.Text
Dim myAdd As String = Add.Text
Dim myQuestion As String = Question.SelectedValue
Dim myAnswer As String = Answer.Text
'指定SQL语句
Mysql = "Insert into(Name_Name,Name,Pwd,Name_Age,Name_Sex,Name_Question,Name_Answer,Name_Add,Name_tel,Name_Email)"
Mysql += "values('" + myName + "','" + myPwd + "','" + myAge + "','" + mySex + "','" + myQuestion + "','" + myAnswer + "','" + myAdd + "','" + myTel + "','" + myEmail + "')"
'创建一个SqlCommand实例
Dim myCommand As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand(Mysql, myConnection)
'执行插入命令
'myCommand.ExecuteNonQuery()
'关闭连接
myConnection.Close()
End Using
Response.Write("<script language=javascript>alert('成功注册')</script>")
Response.End()
' End If End Sub
End Class
==============================================================
这是VS2005(VB)的写法,整不懂了!!请各位大侠指教一下!!!谢谢了!==============================================================
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货