adapter Wizard

[Sam]

Hi ther

"SELECT TOP 10 [Fields] FROM [TableName] ORDER BY [Field] DESC"

I want to use the above code to create a query in the OleDbDataAdapter1 (Wizard)

The aim is to fill a dataset with only the last ten rows of data in decending orde

My Table name is "MyRecords" and the name of the sort column is "Number
Everything I try gives an error in the Wizar
Can some say how I can modify this statement so it work

[Cor Ligthert]

Hi Sam,

The more expirienced people in dotNet newsgroups are not often using the
wizard, however when it is this is an more answered question in the
newsgroup bellow than in this newsgroup.

The wizard will not take all, however I do not know what it will and what
not. Have a try in this newsgroup.

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>
I hope your find your answer there (or here when somebody knows it).

Cor

"SELECT TOP 10 [Fields] FROM [TableName] ORDER BY [Field] DESC"

I want to use the above code to create a query in the OleDbDataAdapter1 (Wizard)
The aim is to fill a dataset with only the last ten rows of data in decending order
My Table name is "MyRecords" and the name of the sort column is "Number"
Everything I try gives an error in the Wizard
Can some say how I can modify this statement so it works

[sam]

I solved this problem by letting the wizard do its thing and then I went into the region area of the form, found the adapter area and the command text and added "TOP 10" right after the word Select in the query strin
Thanks to all