Dim dt As DataTable = New DataTable() QryMaintenanceBindingSource.Filter = "Site like '" & cmbSite.Text & "'" dt = CType(QryMaintenanceBindingSource.DataSource.Tables(QryMaintenanceBindingSource.DataMember), DataTable) 'Don't know why or how this works. DataGridView2.DataSource = dt DataGridView2.Update() DataGridView2.Refresh()
Dim dt As DataTable = New DataTable() Dim myDataView As New DataView(dt) myDataView.RowFilter = "Site like '" & cmbSite.Text & "'" myDataView.Sort = "Site" 'If you like DataGridView2.DataSource = myDataView
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)