DataGrid - can you tell what column is currently used foir the sort?

[Jim]

Hello,

I am creating a windows form application using vb.net 2003 which displays
data in a datagrid, and then, if the user wants, I produce a nicely
formatted crystal report of the data.

The question I have is: if I allow the user to sort the datagrid by
clicking on the column header, is there any way that I can tell which column
the datagrid is sorted on, so that I can sort the data in the crystal report
the same way?

I have not been able to find anything which tells me the current sort for
the datagrid, nor can I figure out how to override the header column click
so that I can set a variable in it...

Any help would be appreciated!

Thanks!

Jim

[Ken Tucker [MVP]]

Hi,

Add a handler to the dataviews list changed event. If you are using
a datatable as the datasource use the datatable's defaultview list changed
event.

Dim ds As New DataSet

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

Dim strConn As String

Dim strSQL As String

Dim da, daEmployees As OleDbDataAdapte r

Dim conn As OleDbConnection

strConn = "Provider = Microsoft.Jet.O LEDB.4.0;"

strConn &= "Data Source = Northwind.mdb;"

conn = New OleDbConnection (strConn)

da = New OleDbDataAdapte r("Select * From Categories", conn)

da.Fill(ds, "Categories ")

daEmployees = New OleDbDataAdapte r("Select * From Employees Order by
LastName, FirstName", conn)

daEmployees.Fil l(ds, "Employees" )

DataGrid1.DataS ource = ds.Tables("Cate gories")

DataGrid2.DataS ource = ds.Tables("Empl oyees")

AddHandler ds.Tables("Empl oyees").Default View.ListChange d, AddressOf
ListChanged

End Sub

Private Sub ListChanged(ByV al sender As Object, ByVal e As
System.Componen tModel.ListChan gedEventArgs)

Dim hti As DataGrid.HitTes tInfo

Dim pt As Point

pt = DataGrid2.Point ToClient(Me.Mou sePosition)

hti = DataGrid2.HitTe st(pt)

Trace.WriteLine (String.Format( "Sort on column {0}", hti.Column))

End Sub

Ken

------------------------
"Jim" <[e-mail].r r.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
Hello,

I am creating a windows form application using vb.net 2003 which displays
data in a datagrid, and then, if the user wants, I produce a nicely
formatted crystal report of the data.

The question I have is: if I allow the user to sort the datagrid by
clicking on the column header, is there any way that I can tell which column
the datagrid is sorted on, so that I can sort the data in the crystal report
the same way?

I have not been able to find anything which tells me the current sort for
the datagrid, nor can I figure out how to override the header column click
so that I can set a variable in it...

Any help would be appreciated!

Thanks!

Jim