从DataGridView更新SQL
问题描述:
我正在从SQL Server 2008数据库表填充DataGridView。 然后我允许用户编辑DataGridView中的值,我正在努力的是如何将这些更改写回按钮按下的SQL表?从DataGridView更新SQL
我使用这个填充:
Try
Dim command As New SqlCommand
Dim adapter As New SqlDataAdapter
DutyRef = DutyRef.Trim
Dim DutyDetails As String = "SELECT * from MyTable WHERE Col1 = 1"
If ds1.Tables("DT_Test").Rows.Count > 0 Then
ds1.Tables("DT_Test").Rows.Clear()
Tab2_DGVDuty.Refresh()
End If
SQLConn = New SqlConnection(SQLConnString)
command = New SqlCommand(DutyDetails, SQLConn)
adapter.SelectCommand = command
adapter.Fill(ds1, "DT_Test")
Tab2_DGVDuty.DataSource = ds1.Tables("DT_Test")
Tab2_DGVDuty.Columns("ID").Visible = False
adapter.Dispose()
command.Dispose()
SQLConn.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
感谢安德烈,大加赞赏 – user1295053 2013-02-12 11:35:42