vb中的问题,通过一个textbox向数据库表里插入数据!!!!!!
Private Sub 保存Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 保存Button.Click
Try
Dim myinsert As String
Dim mycom As SqlCommand
Dim cnStr As String = "Data Source=(local);Initial Catalog=订单信息;Integrated Security=True;"
mycon = New SqlConnection(cnStr)
mycon.Open()
myinsert = "insert into 订单信息(订单NO) values ('" & 编号TextBox.Text.ToString & "')"
mycom = New SqlCommand(myinsert, mycon)
mycom.ExecuteNonQuery() ***********总是在这个地方出错
mycon.Close()
mycon.Dispose()
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub
End Class