Sorting Adodc

[CecileR]

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

Thanks.

Cecile

The more u read, the more u do not know

[Ehsan]

Hi

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

Ehsan

[CecileR]

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

[Z LoveLife]

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