I reading a set of data into Datatable and the same is assigned as a data source to ultrawingrid.
After loading,i'm changing some of the columns as dropdownlist.
Now user can edit any column.
Now i want to know,
How do i find only edited columns and edited rows in order to make a update query and execute it.
please help...
How to: Retrieve Changed Rows
http://msdn.microsoft.com/en-us/library/thc1eetk(v=vs.80).aspx
There's different DataRowStates, so make sure to pay attention to those if you allow adding, deleting, etc that way you know what SQL queries to execute.
Hi,
The grid won't track this information for you. The grid only deals with it's local data source (the DataTable in this case).
Updating the back end is handled by the DataTable and the grid is not involved in that process.
A DataTable tracks the changes made to it. You should consult Microsoft's documentation on the DataTables and DataAdapters, which is what you would typically use to perform your back-end updates.