Query the data in a datagrid?? Help.

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

Have you tried using RS.Filter="field LIKE something" I'm not sure if it forces a reconnect you'll have to try it.

Ed,

Thanks for the reply, but I got it to work using

RS.Sort = "ColName"

Thanks.

Martin