Rowupdating old values
The Grid View control is a tabular databound control but sometimes it is used like a spreadsheet control. NET 2.0 and is an improved version of the Data Grid control. We can use this to display data from a database and edit, sort and select the data.Database Table Structure We are using an "EMPLOYEE" table so the "EMPLOYEE" table design is: Design of Grid View We design a Grid View with which we can perform update and delete operations.Editing the Grid View control can be an incredibly easy feature to add for certain database tables, especially those who have no foreign key associated and can easily be edited through the use of a standard Text Box web control as shown in the figure below: Before we start examining the ASP.NET Grid View markup and associated code lets first enumerate the important code pieces of this tutorial.Here we can update Name, Emp_Code and Emp_Age fields depending on the Id field of the "EMPLOYEE" table.Create SQL Connection We need a connection with a Microsoft SQL Server database so we can access data and perform an operation on it.
NET page that will handle different Grid View events to provide complete editing functionality.Now we define a method for opening a connection with the relation database and returns a SQL connection object depending on the connection string that is passed as a parameter of the Sql Connection class constructor.Delete a Record We can delete a record from the database table by clicking on the delete button that is in the Delete column of the Grid View.You can check row Updated method, I'm getting changed attribute names (actually it calls this method for each change separately).Getting changed value from current row, also retrieving posted value: Second time is invoked for State Province change.