Tech Junkie Blog - Real World Tutorials, Happy Coding!: ASP.NET SqlDataSource Part 4: Enable Pagination, Sorting, Selection

Thursday, July 24, 2014

ASP.NET SqlDataSource Part 4: Enable Pagination, Sorting, Selection

You will notice that when you first create the GridView control all the records are displayed in one page.  You have to scroll just to see all the records.  This can be overwhelming for your users if there are a lot of records.  Also you can not sort or select each record on the GridVidew.




 In this tutorial we will enable "Paging", "Sorting", and "Selection" on the GridView

1.  Click on the ">" icon on the GridView



2.  The "GridView Tasks" panel will be displayed


3.  Check the "Enable Paging", "Enable Sorting", and "Enable Selection" checkboxes


4.  Type Ctrl + F5  to run the application to see the changes


Next: SQL Server: The DELETE statement conflicted with the REFERENCE constraint "FK_Order_Details_Products". The conflict occurred in database "Northwind", table "dbo.Order Details", column 'ProductID'.

1 comment:

Search This Blog