I am fairly new to VB and SQL....I am wanting to sort data in a data grid (bound to ADO control) by various columns ( i.e. like in MS Access....Rt. Click on column)

First is it possible to set up the Data Grid to do this and how?

If now how can I use SQL to Sort the columns?

Thanks