mysql - 在网格单元格值更新时更新数据库表

Question

在我的表单上，我只有 2 个控件，一个包含数据库中每个表的名称的组合框和一个在组合框中选择表时显示数据的网格控件。

网格控制单元格值更改后如何更新数据库表？

这是我填充网格控件的代码：

 Private Sub comboBox_SelectionChanged(sender As Object, e As SelectionChangedEventArgs) Handles comboBox.SelectionChanged
    gridControl.ItemsSource = returnTable("select * from " & comboBox.SelectedItem("TABLE_NAME"))
End Sub

 Public Function returnTable(ByVal queryString As String)
    Dim query1 As String = queryString
    Dim table As New DataTable
    Using connection As New MySqlConnection(konekcija)
        Using adapter As New MySqlDataAdapter(query1, connection)
            Dim cmb As New MySqlCommandBuilder(adapter)
            table.Clear()
            adapter.Fill(table)
            Return table
        End Using
    End Using
End Function

标签： mysqlvb.netdevexpress

Answer 1

您需要捕获单元格值更改事件并按照此 https://www.devexpress.com/Support/Center/Question/Details/Q322494/sharing-value-on-cellvaluesharing-event中的说明更新表格