how do you get the TOP clause to work in ADO.NET? I have tried this SELECT
TOP 1 NOTE FROM NOTES and that works, but soon as i raise the number past 1
it gives me the entire table back! I want the top 5 records not all of them,
how do you get this to work in ado.net with an access db.. thanks!

On Tue, 30 Sep 2003 14:28:43 -0400, "Brian Henry" <(E-Mail Removed)> wrote:

¤ how do you get the TOP clause to work in ADO.NET? I have tried this SELECT
¤ TOP 1 NOTE FROM NOTES and that works, but soon as i raise the number past 1
¤ it gives me the entire table back! I want the top 5 records not all of them,
¤ how do you get this to work in ado.net with an access db.. thanks!
¤

I can't repro this behavior. Are you using the Jet OLEDB provider?


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)