Updating a datagridview
Data graye: Your solution is closer to what I'm looking for and you will get most of the points.Just answer this: I plan to run in disconnected mode but will update the database row by row. My guess is the data retrieval is on the Form_Load. They have to do with redrawing the control which is why new rows don't appear.Table Adapter uses the key column in the Where clause of its Update and Delete statements so if the value of key column changes, things get messy. Then I have a separate "Update" button that the users pushes to start the update process.
I would like to give users the ability to update from the datagridview and have the program immediately update the sql server table. Now I am wondering which events to use to validate and update the database, wheter to enable/disable the validating events? The problem is that I'm trying to edit, validate and update behind the scenes by allowing the user to make changes directly to the grid.
What you shouldn't do, ever, unless you really know what you're doing: call Accept Changes.
All that will do is set all of the Data Rows in the Data Table to Unchanged (and it will remove all Deleted rows from the Rows collection), which means that future calls to the Update method won't see added/modified rows and the underlying database won't get updated.
Step 1Create a Windows Forms Application Project, and place a Data Grid View on the form. As: Points of Interest You can insert a row and click the update button; a row in the database will be inserted.
Step 2Click on the pin button on right-up side of Data Grid View and click add project Data Source. If you update any cell and click the update button, then the database will be updated.