DataList, DataSet or DataTable rows limit

[Aahz]

Hello;

I have an XML file with data which I show in DataList sucessfully,
using DataSet
Problem is that XML has about 30 records which is too much I need to
show just first 10 ordered by date (10 newest)

I don't know how to do this.

Any help is highly appreciated

Thanks

[Peter Bromberg [C# MVP]]

Aahz,
this sounds like an ASP.NET question, so the c# group probably might not
have been the best place to post it.

To page a DataList, you would need to add a "pagerbar" control to it; the
DataList does not come with paging built-in as the DataGrid does.

Look around, I've seen a few implementation of the "Paging DataList".

Alternatively, you can filter and sort your dataset prior to binding to the
DataList.
--Peter

Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Aahz" wrote:

Hello;

I have an XML file with data which I show in DataList sucessfully,
using DataSet
Problem is that XML has about 30 records which is too much I need to
show just first 10 ordered by date (10 newest)

I don't know how to do this.

Any help is highly appreciated

Thanks

[Michael Nemtsev]

Several cases
1) Use XSLT
2) Use DataTable.Select with aggregating function

Hello;

I have an XML file with data which I show in DataList sucessfully,
using DataSet
Problem is that XML has about 30 records which is too much I need to
show just first 10 ordered by date (10 newest)

I don't know how to do this.

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Aahz]

2) Use DataTable.Select with aggregating function

Can you please elaborate this little bit

Thanks

[Michael Nemtsev]

Hello Aahz,

See there http://msdn2.microsoft.com/en-us/lib...xpression.aspx
try to play with that function to get what you need

2) Use DataTable.Select with aggregating function

A> Can you please elaborate this little bit
A>
A> Thanks
A>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Manu]

You may be interested in my pager control:

http://www.manuelabadia.com/livedemo/pagerdatasource/

that lets you add paging support for any asp.net control with no code
at all if you use a data source control.

Manu.

Aahz ha escrito:

Hello;

I have an XML file with data which I show in DataList sucessfully,
using DataSet
Problem is that XML has about 30 records which is too much I need to
show just first 10 ordered by date (10 newest)

I don't know how to do this.

Any help is highly appreciated

Thanks