«

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

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 ?
>
>
>

"Deasun" <> wrote in message
news0DB3D33-FC32-4281-8CF8-...

> SELECT TOP 20
> *
> FROM TBL_TABLENAMEHERE
>
> Will do what you asked.

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

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

"Deasun" <> wrote in message
news0DB3D33-FC32-4281-8CF8-...
> 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 ?
> >
> >
> >

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

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" <> wrote in message
news: ups.com...
> dr() = datatable.select ("select Top 20 from tblorders")
>

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]" <> wrote in message
news:...
> 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" <> wrote in message
> news: ups.com...
> > dr() = datatable.select ("select Top 20 from tblorders")
> >
>
>

[P-Dub]

using System.Linq;
...
dataTable.Take(20);