VB.NET高手一定要看看!
我是个初学者,写个了数据库程序,相关字段自动绑定到文本框,我在删除数据记录(物理数据库已成功显示)但文本框中仍然保留有已删除的数据,怎样解决这个问题.代码如下:
Dim connStr As String = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "\my.mdb"
Dim cn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(connStr)
Dim DbCommand As New OleDb.OleDbCommand
DbCommand.CommandType = CommandType.Text
DbCommand.CommandText = "delete from baseinfo where sfzhm='" & Me.sfzhmText.Text & "'"
DbCommand.Connection = cn
cn.Open()
DbCommand.ExecuteNonQuery()
cn.Close()
MsgBox("数据删除成功!")
Me.BaseinfoBindingSource.MoveNext()