我aspx。vb的代码如下:
MyConnection = New System.Data.SqlClient.SqlConnection()
Dim DS As New System.Data.DataSet
MyConnection.ConnectionString = "Server=(local);Database=edu;UID=sa;pwd=2829362;"
MyConnection.Open()
Sqlstr = "insert into answer (姓名,身份,手机,固话,邮箱,区域,ly) values('" & txt_xm.Text & "','" & jzxb & "','" & txt_sj.Text & "','" & txt_gh.Text & "','" & txt_yx.Text & "','" & txt_qy.Text & "','" & txt_nr.Text & "')"
MyCommand = New System.Data.SqlClient.SqlDataAdapter(Sqlstr, MyConnection)
MyCommand.Fill(DS)
MyConnection.Close()本来应该插入一条记录的,但不知道为什么数据库插入了2条记录,究竟是什么原因啊?那位大虾能帮忙解决,谢谢
MyConnection = New System.Data.SqlClient.SqlConnection()
Dim DS As New System.Data.DataSet
MyConnection.ConnectionString = "Server=(local);Database=edu;UID=sa;pwd=2829362;"
MyConnection.Open()
Sqlstr = "insert into answer (姓名,身份,手机,固话,邮箱,区域,ly) values('" & txt_xm.Text & "','" & jzxb & "','" & txt_sj.Text & "','" & txt_gh.Text & "','" & txt_yx.Text & "','" & txt_qy.Text & "','" & txt_nr.Text & "')"
MyCommand = New System.Data.SqlClient.SqlDataAdapter(Sqlstr, MyConnection)
MyCommand.Fill(DS)
MyConnection.Close()本来应该插入一条记录的,但不知道为什么数据库插入了2条记录,究竟是什么原因啊?那位大虾能帮忙解决,谢谢
Using conn As New SqlConnection(connstr)
conn.Open()
Dim MyCommand As New SqlCommand("", conn)
MyCommand.ExecuteNonQuery()
conn.Close()
End Using
使用Parameters实现数据insert