For demonstration purposes, I created a database (named Database.mdf) in which we have a table (named tbl_Employee).Save all or press "Ctrl S" and hit "F5" to run the page, the page will look as in the following image: Click on "Edit the Grid View", it will display Textboxes in each cell as in the following image: Edit the value(s) here and click on the Update link, it will update all the data or to remove it click on the "Delete" link above the image shown.We define a connection in the web.config file and give a name to the connection string.Now we access this connection string on the page so we can open a connection with the relation database. The first one accesses the connection string and the other is for the SQL connection.When attached with a Data Source control Grid View performs tasks such as paging, sorting and editing automatically i.e. However, at times you require to bind the Grid View with a Data View or Data Table directly.
In order to implement paging you need to set Allow Paging property of the Grid View control to True. There are two events of Grid View that are related to paging. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I have a Grid View and have converted a Bound Field into a Template Field. Command Name = "notes" Then Dim index As Integer = Convert. Command Argument) Dim my Selected Row As Grid View Row = Grid View2. NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This calls for some extra coding from developer's end. As an example we are going to use Employees table of the Northwind database. Add three Bound Fields and a Command Field to the Grid View with the help of Fields dialog (see below).In order to develop a test web form create a new web site in VS. Set various properties of the Bound Fields as shown in the following table: Here, we call Bind Grid() method if the web form is being served as a result of first request.