Thursday, March 22, 2012

Simple Datalist Question

I have fallen in love with the datalist control in .Net... but now its testing my patience. In all the other times I have used it, I have had a small database that I didn't particularly care if it listed the entire database.

This time is different. I want to take the last five entries in my table (using an automnumber ID field as primary key) and bind them toa datalist.

What code am I needing to limit the datalist to only 5 entries instead of the entire table of data?

HWOODKY
:)post your code. It may be as simple as modifying a sql statement.
Use store procedures,
SELECT TOP 5

0 comments:

Post a Comment