求助VB.NET中 TEXTBOX1绑定了access数据库中某条记录 怎么样做到在TEXTBOX1中更改数据点击button更新该条数据
如TextBox1.DataBindings.Add("text", ds.Tables("yonghu").DefaultView, "Name")在窗口打开时TEXTBOX1里面是显示读取到的Name,要直接在TEXTBOX1中更改、输入
这样如何更新这条数据,求详细点的代码,尤其是UPDATE部分
另外为什么我这个update语句老报错
Dim conn As OleDb.OleDbConnection
Dim cmd1 As OleDb.OleDbCommand
Dim SQL As String
Dim Rd As OleDb.OleDbDataReader
If RadioButton1.Checked = True Then
Try
conn = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source='" & str & "'")
conn.Open()
SQL = "update [yonghu] set dengji = 0,Name = '" & Me.TextBox1.Text & "',Password= '" & Me.TextBox2.Text & "'"
cmd1 = New OleDb.OleDbCommand(SQL, conn)
Rd = cmd1.ExecuteReader()
Conn.Close()
MsgBox("编辑成功!")
Catch ex As Exception
MsgBox(ex.Message)
End Try
新手求助,谢谢大家 --------------------编程问答-------------------- Rd = cmd1.ExecuteReader()
=>
cmd1.ExecuteNonQuery() --------------------编程问答-------------------- OleDbCommandBuilder --------------------编程问答--------------------
這句出錯 Rd = cmd1.ExecuteReader()
改為 cmd1.ExecuteNonQuery
--------------------编程问答-------------------- 一楼正解!
补充:.NET技术 , VB.NET