TimHudspith
asked on
Update database from datagridview
On a form I have a datagridview bound to a table in a SQL Server database. When I make edits to the data in the DGV the changes are not being written back to the database. How do I do it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Create a save button
ASKER
This works, but only if I create a SqlCommandBuilder first.
Using cmdbl As SqlCommandBuilder = New SqlCommandBuilder(dap)
dap.Update(tblGridSource)
End Using
ASKER