vb.net中通过查询命令将数据显示到DataGridView表中,在DataGridView表中修改后UPdate回数据库中
zcgvb 2018-07-23 10:14:02 通过两个命令按钮完成操作
点击“查询”命令按钮,数据查询结果显示到DataGridView中
Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = d:\dygl.mdb;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=111"
Dim myConn As OleDbConnection = New OleDbConnection()
myConn.ConnectionString = ConnectionString
myConn.Open()
Dim strCom As String = "SELECT * FROM dysjk where 身份证号='" + TextBox21.Text + "' "
Dim gjqyDataSet As New DataSet
Dim dt As New DataTable
Dim gjqyCommand1 As OleDbDataAdapter = New OleDbDataAdapter(strCom, myConn)
gjqyCommand1.Fill(gjqyDataSet)
dt = gjqyDataSet.Tables(0)
DataGridView1.DataSource = dt
myConn.Close()
End Sub
在查询结果的DataGridView1表中直接修改数据,然后点击“保存”按钮列表数据更新回数据库中
请大家指导一下