从vb.net中的数据网格视图更新数据库

' 建立与数据库的连接
Dim connectionString As String = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword"
Dim connection As New SqlConnection(connectionString)
connection.Open()

' 创建DataAdapter对象并填充数据集
Dim selectQuery As String = "SELECT * FROM YourTable"
Dim dataAdapter As New SqlDataAdapter(selectQuery, connection)
Dim dataSet As New DataSet()
dataAdapter.Fill(dataSet, "YourTable")

' 将数据集绑定到数据网格视图
dataGridView.DataSource = dataSet.Tables("YourTable")

' 修改数据集中的数据
dataSet.Tables("YourTable").Rows(0)("ColumnName") = "NewValue"

' 保存修改后的数据回数据库
dataAdapter.Update(dataSet, "YourTable")

' 关闭连接
connection.Close()