what is the easiest way to select top 20 rows from a datatable ?

[Ersin Gençtürk]

I can't find a expression for table views did i missed something ?

[Deasun]

SELECT TOP 20
*
FROM TBL_TABLENAMEHERE

Will do what you asked.

Deasun

"Ersin Gençtürk" wrote:

I can't find a expression for table views did i missed something ?

[Mark Rae]

"Deasun" <De****@discussions.microsoft.com> wrote in message
news:D0**********************************@microsof t.com...

SELECT TOP 20
*
FROM TBL_TABLENAMEHERE

Will do what you asked.

Assuming the RDBMS supports the "TOP" reserved word...

[Ersin Gençtürk]

I mean selecting from datatable , you know asp.net datatable object , not
from database table!

"Deasun" <De****@discussions.microsoft.com> wrote in message
news:D0**********************************@microsof t.com...

SELECT TOP 20
*
FROM TBL_TABLENAMEHERE

Will do what you asked.

Deasun

"Ersin Gençtürk" wrote:

I can't find a expression for table views did i missed something ?

[BillGatesFan]

dr() = datatable.select ("select Top 20 from tblorders")

[Yunus Emre ALPÖZEN [MCAD.NET]]

It never works !!! DataTable.Select() works as a where clause...

I assume SourceTable contains whole data and u don't need to sort it.

DataTable outputTable = SourceTable.Clone();
for(int i=0;i<20;i++)
outputTable.ImportRow(SourceTable.Rows[i]);

outputTable contains top 20 records.

--

Thanks,
Yunus Emre ALPÖZEN
BSc, MCAD.NET

"BillGatesFan" <kl******@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

dr() = datatable.select ("select Top 20 from tblorders")

[Ersin Gençtürk]

thanks yunus ,

already this is the way that I am doing it.I think there is no other way to
do it with dataview.

"Yunus Emre ALPÖZEN [MCAD.NET]" <ye***@msakademik.net> wrote in message
news:ec**************@TK2MSFTNGP15.phx.gbl...

It never works !!! DataTable.Select() works as a where clause...

I assume SourceTable contains whole data and u don't need to sort it.

DataTable outputTable = SourceTable.Clone();
for(int i=0;i<20;i++)
outputTable.ImportRow(SourceTable.Rows[i]);

outputTable contains top 20 records.

--

Thanks,
Yunus Emre ALPÖZEN
BSc, MCAD.NET

"BillGatesFan" <kl******@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

dr() = datatable.select ("select Top 20 from tblorders")