The following is an example that shows how to update the database when the end user deletes a grid row.We will handle the events, Deleting Rowby User and Deleted Rowsby User, which will be fired only once even if users select and delete more than one row at once.
Database Table Structure We are using an "EMPLOYEE" table so the "EMPLOYEE" table design is: Design of Grid View We design a Grid View with which we can perform update and delete operations.
Here we can update Name, Emp_Code and Emp_Age fields depending on the Id field of the "EMPLOYEE" table.
It allows users updating the data base while the end user is up to exit the applications, or click a special button.
Moreover, when developers need update the data base as the end user finishing the changes to a single value of Kettic Grid View, they can implement the data base updating with ADO. NET Data Table which have loaded data from a Sql Data Adapter and is bound to a Binding Source component to Kettic Grid View control.
When a Grid View row is in edit mode then we can update the row's record in the relational database table.