somali interracial dating - Updating a gridview

In this article, we will explore how to add, update, delete and select a record from sql server database using gridview control in a simple way.

I’m using visual studio 2008 and sql server 2008 for this sample.

updating a gridview-72

In the below gridview I used templatefields to display data and perform gridview operations. Templatefield: Actually we use this templatefield to display any control such as check box, label, drop down etc in the gridview control to provide additional functionality and this templatefield supports many templates, here we are using Itemtemplate, Edititem Template and Footer Template.2.

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.

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.

NET [97] Chart [27] Grid View [24] AJAX [15] JQuery [14] Google chart [13] Fusion Charts [8] i Text Sharp [8] PDF [8] ASP.

aspdotnet-suresh offers C#articles and tutorials,csharp dot net,articles and tutorials, VB.

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.

Copy the below code and paste into aspx page as shown below.

Many a times in our applications we use primary keys to get control of the particular record in the gridview.

Tags: , ,