Code for gridview rowupdating in asp net
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.
You'll be able to ask questions about coding or chat with the community and help others. A datakey represents the primary key field or field of a record that can uniquely identify it in a data-bound control. Row Index represents the index of the particular row.Many a times in our applications we use primary keys to get control of the particular record in the gridview. 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.For example a Sql Data Source, which is automatically added to your Web Form if you drag-n-drop your way around Visual Studio 2005.
The problem is, I’d very much like to do so, if ASP. But I can’t set a Data Source property or anything on the Sql Data Source!!! I probably have to read the cells on the Grid View of the selected row, find the controls, get the values from those and insert those into my Data Set.
In this example, I am going to retrieve values from categories table of Northwind database. Drag a Grid View into the Web Form and assign Data Key Names property with the primary key column i.e. In the gdview_Row Editing and gdview_Row Deleting event, we have used the below code to retrieve categoryid from datakey of Grid View, int catid = int.
Welcome to the Coding Forums, the place to chat about anything related to programming and coding languages.
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.
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.