SELECT TOP query - in datatables

Is a SELECT TOP query allowed in filtering rows from a
datatable? If it is not, is there any other easy way to
filter a given number of rows from a datatable? Thanks a
lot for your help.

[Jochen Kalmbach]

wrote:

Is a SELECT TOP query allowed in filtering rows from a
datatable? If it is not, is there any other easy way to
filter a given number of rows from a datatable? Thanks a
lot for your help.

it depends on the database...
some database support this feature (like SQL-Server, Oracle), and some does
not (like MS-Access).

--
Greetings
Jochen

Do you need a memory-leak finder ?
http://www.codeproject.com/tools/leakfinder.asp

Do you need daily reports from your server?
http://sourceforge.net/projects/srvreport/

Thanks for your reply. But, my question is can I write a
SELECT TOP query in C# to filter rows from my datatable?
(not from my SQL server database). Thank you.

-----Original Message-----
wrote:

Is a SELECT TOP query allowed in filtering rows from a
datatable? If it is not, is there any other easy way to
filter a given number of rows from a datatable? Thanks a lot for your help.
it depends on the database...
some database support this feature (like SQL-Server,

Oracle), and some doesnot (like MS-Access).

--
Greetings
Jochen

Do you need a memory-leak finder ?
http://www.codeproject.com/tools/leakfinder.asp

Do you need daily reports from your server?
http://sourceforge.net/projects/srvreport/
.

[Alfred Taylor]

According to

http://msdn.microsoft.com/library/de...ssiontopic.asp

DataTable.Select does not support the TOP keyword. Looks like you'll have
to implement it yourself.

<an*******@discussions.microsoft.com> wrote in message
news:1a*****************************@phx.gbl...

Thanks for your reply. But, my question is can I write a
SELECT TOP query in C# to filter rows from my datatable?
(not from my SQL server database). Thank you.

-----Original Message-----
wrote:

Is a SELECT TOP query allowed in filtering rows from a
datatable? If it is not, is there any other easy way to
filter a given number of rows from a datatable? Thanks a lot for your help.

it depends on the database...
some database support this feature (like SQL-Server,

Oracle), and some does

not (like MS-Access).

--
Greetings
Jochen

Do you need a memory-leak finder ?
http://www.codeproject.com/tools/leakfinder.asp

Do you need daily reports from your server?
http://sourceforge.net/projects/srvreport/
.