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, all
After user sorted a column in datagrid, or I should say after user click a
column title to sort it, does this raise any event? if yes, how can I catch
this
event? becuase I need to do something after sort is completed.
Thanks in advance.