2
Answers

Using Paging for huge amount of data (Need SQL and Function)

Hi....... 

I am using 3 tier architecture in ASP.NET. I have so many tables in my database and some table has 1000's of data. In earlier forums , i saw answers that use 
paging for gridview instead of filling the full dataset. Can any one give me an idea on using this paging and can any one give me what would be the sql statement 
on using paging. 

Please give me detail information as am new to these architectures and methods. 

Thanks and Regards 
Sankar

Answers (2)

1
Photo of Prasham Sabadra
NA 17.6k 1.2m 8y
Hi Venkat,
Please try this
<script src=”/_layouts/SP.js” type=”text/ecmascript”></script> 
Accepted
1
Photo of Ramesh Palaniappan
NA 13.2k 722.6k 8y
Please add this line to call your function
  1. ExecuteOrDelayUntilScriptLoaded(myjsfucntion,"sp.js");