Update SQL From DataGridView

Question

I am populating a DataGridView from a SQL Server 2008 database table. I then allow users to edit the values in the DataGridView, what I am struggling on is how to then write these changes back to the SQL table on a button press?

I am populating using this:

 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

Andrey Gordeev · Accepted Answer · 2013-02-12 11:30:55Z

2

Take a look at SqlDataAdapter.Update

This article may help you: How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual Basic .NET

edited Feb 12, 2013 at 11:30

answered Feb 12, 2013 at 11:16

Andrey Gordeev

32.7k16 gold badges143 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update SQL From DataGridView

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related