C# GridView Paging - databasae
This article demostrate how to enable paging, by connect database object source with grid view.
click grid view and select choose object source
this database connection will add to webconfig file
you could use regular sql and stored procedure
Since you connect you source object to datbase, how code looks like? Is should be bad? lots sql on client? Let's check the actual source
So, bad practise for this is, you put your sql to your UI. eventhough you don't see it on your actual HTML, but, if you have layor like, business logic layor and data layor, you should put your sql to data layor, It's not good to build a SOA service based application too, since you put your sql logic on your web application.