Updating row in gridview
The C# code API for data editing, data inserting, as well as data deleting are included within the Grid View Control.UI designer of the data grid can easily use the API to build the grid data editing behavior for columns and rows.In the next step, select the table and the specific columns you want to retrieve.Also, click the Advanced settings and check the “Generate INSERT, UPDATE and DELETE statements”. From the Grid View “Smart Tasks” arrow, check enable Paging and Sorting. The “Item Template” is what we see when the gridview is in Normal mode.
On Row Updating is fired when the 'Edit' button is clicked. Is the data bound to the gridview, your gridview markup doesn't say that it is bound to Category Name. There’s a Click event handler assigned to the Add Button.When the Button is clicked, the Insert function of the Sql Data Source is executed which then inserts the records to the database and binds the Grid View again to display the newly inserted record.Now you have to specify which database the Sql Data Source control will get data from. Click Next two times, leaving the default connection String name.At the end of this wizard, a “connection Strings” element will be added to your Web.config file.
The Kettic Data Grid View Control for Windows Forms provides powerful data editing functionalities.