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).
The Data View supplies all the records from the Employees table.
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.
A Grid View Row Event Args object is passed to the event-handling method, which enables you to access the properties of the row being bound.
string connetion String = "YOUR_CONSTR" ; string upd Stmt = "UPDATE Quantity set [email protected]_pro4, [email protected]_pro5, [email protected]_profile5 " "where [email protected] Name"; using (Sql Connection cnn = new Sql Connection(connetion String)) I have tested this code, and it reads the table, and allows the edits of the records.
We need to access this variable from Bind Grid() method so that our sorting will work correctly under all the circumstances. The following figure shows the Grid View after implementing sorting.