高手帮我看一下下面的代码错在哪?写入数据老师报错!

来源:百度知道 编辑:UC知道 时间:2024/07/05 13:38:39
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim connstring As String
Dim strsql As String
Dim conn As New OleDbConnection

connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "
connstring += Server.MapPath("Data.mdb")
conn.ConnectionString = connstring

conn.Open() '打开连接

Dim cmd As New OleDbCommand

strsql = "select count(*)from students where stno='" & TextBox1.Text & "'"
cmd.Connection = conn
cmd.CommandText = strsql

Try

strsql = "Insert into Students values( '" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "' ,'" & TextBox4.Text & "','" & Textbox5.Text & "',

插入数据要确定你数据库中要插入值的这些列是否都是char或vchar类型的字段如果不是就不要家'' 不然很容易出错

Insert into Students value后面的字段是全部添加的吗,如果不是就把字段名也写出来吧
还有你这个页面好像没有接收的request吧,那你那些值是从哪儿来的啊