DataGridView to update database tables
Forum rules
Do not post any licensing information in this forum.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Do not post any licensing information in this forum.
Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Re: DataGridView to update database tables
I am not saying never use it. You cannot use it to create a connected data table. With the adapter we get the correct pieces to auto-generate the update/insert/delete SQL. When we execute the $datatable.Update() command the data is posted back. Only changes are posted. All changes including inserts, updates and deletes are posted as a set of batches.
Re: DataGridView to update database tables
Ok. I got it. That's very cool--Only changes getting updated. That's a huge plus. Thank you for all the information. I love the tool. It is very handy.jvierra wrote:I am not saying never use it. You cannot use it to create a connected data table. With the adapter we get the correct pieces to auto-generate the update/insert/delete SQL. When we execute the $datatable.Update() command the data is posted back. Only changes are posted. All changes including inserts, updates and deletes are posted as a set of batches.