Next Previous Last Arrows 1

[kurie]

Hi ALL
In asp.net how do i program code for next, previous arrows for SQL Server. I have done it with MYSQL before and its easier beacuse of the limit function in MySQL. does anyone know how im suppose to do it for SQL SErver.

Thanks you

 

[jmeckley]

do you mean << < > >> for navigating a page of data? the arrows are a UI concern and the paging mechanics are a sql concern. you can solve both a number of ways. All the ORMs have a built-in paging which will build the sql for you. If you are writing raw sql statements, then google "ms sqlserver page results" or something like that. depending on the version of sql server will influence the tsql statement(s).

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259

 

[kurie]

thanks very much
Jason.