It provides the feature of reflecting the changes made to a Data Set or an instance of the SQL server data.
The Command Builder opens the Connection associated with the Data Adapter Object and makes a round trip to the server each and every time and it's asked to construct the action queries.
By using the Grid View Row object we can find the reference of any control in the row in which user is editing the data.
In this tutorial we are searching for our Text Box controls txt Product Name and txt Unit Price.
By Default, Grid View control displays Item Template which directly shows the Product Name and Unit Price columns but when user clicks Edit button Grid View automatically switches to Edit Item Template and display the control available inside Edit Item Template for user editing.Here in Grid View, in the beginning the major part is to make the decision of putting either a bound field or a template field and the answer is simple: When we want to place any control inside the Grid View then we can go for template field, otherwise bound field will be simpler.I hope the above information was a little bit helpful for you, kindly let me know your valuable feedback or thoughts.If user clicks the Cancel button while Grid View is in editing mode, you need to Cancel the Editing process and also need to reset the Edit Index property to -1 in the Row Canceling Edit event of the Grid View control as shown below: The last step is to handle the Row Updating event to actually update the back end database.To do this we first need to obtain the reference of the current row by using its index no as shown in the first line below.