Asp net gridview onrowupdating example
In this article, I am going to explain how to manipulate data using Grid View control.
This article scope is limited to Updating and Deleting records using Grid View and I am not using any readymade Data controls for that but manually writing all event methods.
" End If End Sub Protected Sub grid View_Row Editing(By Val sender As Object, By Val e As Grid View Edit Event Args) grid View. New Edit Index load Stores() End Sub Protected Sub grid View_Row Updating(By Val sender As Object, By Val e As Grid View Update Event Args) Dim stor_id As String = grid View.
To String() Dim stor_name As Text Box = Direct Cast(grid View.
Find Control("txtname"), Text Box) Dim stor_address As Text Box = Direct Cast(grid View.
Find Control("txtaddress"), Text Box) Dim city As Text Box = Direct Cast(grid View.
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.
Now let’s start with putting the Grid View on page. Data Key Names="Auto ID" Auto Generate Edit Button="True" On Row Editing="Edit Record" On Row Canceling Edit="Cancel Record" On Row Updating="Update Record" Cell Padding="4" Header Style-Horizontal Align="left" On Row Deleting="Delete Record" Row Style-Vertical Align="Top" Fore Color="#333333" Grid Lines="None" In the above code, I have kept Auto Generate Columns as false so that Grid View will not render all the fields of the data source automatically.
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.
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.
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.