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(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim strConn As String
Dim strSQL As String
Dim da, daEmployees As OleDbDataAdapter
Dim conn As OleDbConnection
strConn = "Provider = Microsoft.Jet.OLEDB.4.0;"
strConn &= "Data Source = Northwind.mdb;"
conn = New OleDbConnection(strConn)
da = New OleDbDataAdapter("Select * From Categories", conn)
da.Fill(ds, "Categories")
daEmployees = New OleDbDataAdapter("Select * From Employees Order by
LastName, FirstName", conn)
daEmployees.Fill(ds, "Employees")
DataGrid1.DataSource = ds.Tables("Categories")
DataGrid2.DataSource = ds.Tables("Employees")
AddHandler ds.Tables("Employees").DefaultView.ListChanged, AddressOf
ListChanged
End Sub
Private Sub ListChanged(ByVal sender As Object, ByVal e As
System.ComponentModel.ListChangedEventArgs)
Dim hti As DataGrid.HitTestInfo
Dim pt As Point
pt = DataGrid2.PointToClient(Me.MousePosition)
hti = DataGrid2.HitTest(pt)
Trace.WriteLine(String.Format("Sort on column {0}", hti.Column))
End Sub
Ken
------------------------
hi there,
Does anyone know which event is been called after any column hearders had
been clicked?
My problem is that the data grid lost selected the row and started an
endless loop after I clicked any columns header in the data grid.
thanks
Jeff
