«

Hi there.

Just wondering if there is some way to make the Datalist webcontrol,
only iterate a prespecified number of times?

Like setting a property (MaxRows perhaps!?).


--

+================================================= =====================+
| SparrowHawk The Magician |
| |
| |
| |
| |
+================================================= =====================+
| e-mail: sparvhok[NOSPAM]hotmail.com |
+================================================= =====================+
To send me an email, replace the [NOSPAM] tag with @ sign.

The easiest way is to just limit the data coming back from the database.
You could use the TOP keyword to limit the results returned. For
example, to return 10 records use:

SELECT TOP 10 *
FROM TableName

hth

--

Scott Mitchell

http://www.4GuysFromRolla.com

* When you think ASP.NET, think 4GuysFromRolla.com!

Scott Mitchell [MVP] wrote:
> The easiest way is to just limit the data coming back from the database.
> You could use the TOP keyword to limit the results returned. For
> example, to return 10 records use:
>
> SELECT TOP 10 *
> FROM TableName
>
> hth
>
Yes, I know. And that is probably the most sane thing to do, since you
dont want to extract more than neccesary from the DB. One shouldnt hog
the database connection more than nec...

ok, thanx for the answer.

--

+================================================= =====================+
| SparrowHawk The Magician |
| |
| |
| |
| |
+================================================= =====================+
| e-mail: sparvhok[NOSPAM]hotmail.com |
+================================================= =====================+
To send me an email, replace the [NOSPAM] tag with @ sign.