ASP.NET 2.0: Populating a Datalist using a T-SQL Stored Procedure & Datalist Custom Paging

Posted on July 21, 2008. Filed under: .NET | Tags: asp.net, datalist |

Highlights:
- Dataset with 2 tables
- Custom paging on the Datalist
- Stored Procedure returns only the records needed for a page. This is useful when the table has thousands of rows
- Source code in both VB 2005 and C# 2005
Source Code Snippets: VB 2005, C# 2005, T-SQL, web.config
To see the demo, please go to: http://www.jotnow.net
VB 2005:
DataList:
<asp:Literal [...]