Now we have created the application and open the web.config file to add connection string as shown below.
Connection string must be based on your database details. Drag the gridview control from tool box and placed into the page and make it Autogeneratecolumns as false, so manually we will create the gridview columns to display.
Actually gridview control is built with lot of features and this control is commonly used for all applications.
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.
Execute the below SP_Customer stored procedure in sql server database which is used to handle insert, update, select and delete a record into customer table.
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.
Now we have prepared the all database related activities for this and moving to front end side to setup aspx page and codebehind file to handle gridview operations, so first create the web application and add Gridview page as shown below.
Find Control("txt Edit Email") as Text Box; Label username = grd Manage Faculties.