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 ?

 

[Guest]

SELECT TOP 20
*
FROM TBL_TABLENAMEHERE

Will do what you asked.

Deasun

 

[Mark Rae]

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!

 

[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);

outputTable contains top 20 records.

 

[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.

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);

outputTable contains top 20 records.

--

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

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