Aspx gridview updating
In this article however, I'll show you how a Grid View control can be used to update (edit), delete and insert data in a remote SQL Server table.
In practical scenario you should use your existing architecture to populate and update the data.
In this article, I am going to take a simple database table that has following fields: Auto ID - Int, Auto Increment, Primary Key Page Name - Varchar(50) Page Description - Varchar(500) Active - Bit(1) In this article, I am not going to explain the workings of Sql objects but focusing on the events and methods of the Grid View that will help us in updating and deleting the records.
We have selected four columns from Employee Details table.
In this article, I am going to explain how to manipulate data using Grid View control.
Then I have several methods attached with following events Get video of hundreds of ASP. On Row Editing - Edit Record On Row Cancel Edit - Cancel Record On Row Updating - Update Record On Row Deleting - Delete Record As I set Auto Generate Columns property to false so I am going to manually write the fields name that I need to appear in the way I want. In Bind Data() method, I am getting the data from database using Sql objects and specifying the Data Source property of the Grid View to the Pages Data table of the Data Set.
So I have to specify how I want them to appear in the normal view and edit view. When Edit link of the Grid View will be clicked then On Row Editing event will fire that will call Edit Record method.