Datagrid - what column is it sorted by?

How do I determine what column the user sorted the textbox by and wether its ASC or DESC? (they click the header and a little arrow shows up.

When they leave the form, I want to pick up what column they sorted by so when they come back, I can sort that column for them
I already have the filter piece on the dataview and move to the row they were on by useing Me.DataGrid1.CurrentRowIndex = x.

Please help. I have spent hours trying to figure this out
Thanks very much for your time.

Chris
Wed Feb 25 15:50:53 CST 2004

Sean, it is pretty much the same as the filter piece, just grab the value of
the Sort property of the DataView and when they return to the form stick the
value back into the Sort property - it will sort it the way it was sorted,
the correct field and also ASC or DESC.

"Sean Davis" <sdavis_mn@hotmail.com> wrote in message
news:B96BF0F2-1F46-41CE-BB61-29E552076D1A@microsoft.com...
> How do I determine what column the user sorted the textbox by and wether
its ASC or DESC? (they click the header and a little arrow shows up.)
>
> When they leave the form, I want to pick up what column they sorted by so
when they come back, I can sort that column for them.
> I already have the filter piece on the dataview and move to the row they
were on by useing Me.DataGrid1.CurrentRowIndex = x.
>
> Please help. I have spent hours trying to figure this out.
> Thanks very much for your time.

anonymous
Wed Feb 25 17:31:06 CST 2004

Your the best. Thanks