Asp gridview rowupdating validation
In general, gridview control is used to populate the data in tabular format from different datasources and basically it derived from webcontrol class.
Actually gridview control is built with lot of features and this control is commonly used for all applications.
Item Template : This template used to display the content every row rendered by the gridview control.This is the easy way to handle all the gridview operations in data base side instead of using sql query from front end side.Also here we used @@ERROR for error handling in the stored procedure and returns the number to front end and confirm that the performed action is successful or not.Mainly used when we edit a particular row in the gridview control.Here we use textbox control to display the data, while editing a row in the gridview.4.And here I’m explaining some basic functions of this gridview control such as insert edit and delete a record.First, we need to prepare the database table and stored procedure for gridview operations such as insert, update & delete a records, here I’m using sql server 2008 for all database activities, for this sample I have created the customer table and stored procedure for all mentioned gridview operations.To enable data editing in Web Data Grid™, add the Cell Editing behavior to the Behaviors collection. The Edit Mode Actions property of the Cell Editing behavior lets you determine what actions will cause a cell to enter edit mode. Create the customer table in your own test database using below table script and insert some records initially to load gridview with data.Once you execute the above table and insert scripts, you will get the below records in the table initially to load data into gridview control.