Hello everyone,

Okay, so I have ADODC and Datagrid. The table content is being displayed in the datagrid in a disconnected mode.

What I want to do is have a combobox with a list of the column names so that user can SORT the data whichever they like. I want to do this by not having to send a new query to the SQL Server, because that is slow. Is it possible?

In other words, I want the user to be able to SORT and RE-SORT the data that is being shown on the datagrid (as many times as they like), without sending a new query to the SQL Server.

So I want to be able to do something like:
"SELECT * FROM datagrid1.something ORDER BY colname"

Please post any thoughts or ideas, or anything at all. Thanks a lot.

Martin