Sorting Adodc

Anyone, help me please. How do i sort data in ADODC control?..

Thanks.

Cecile

The more u read, the more u do not know

Hi

If you use sql command to retrieve data, you can use "ORDER BY" sql command.

Ehsan

But then I'm using recordset.

Adodc1.Recordset.Sort #i dont what else

if I use
Adodc1.Recordset.Sort = "Field"

it tells error that this not support the funtion...




The more u read, the more u do not know

use sql instead of a table as your ADODC recordsource.
ie select [your fields here] from [table name here] Order by [your sort fields here]

hope this helps