-
Datagrid problem
Ok I have a datagrid that is bound to a dataset. I what my users to be able to (1) filter the dataset from a combobox selection. (2) once filtered and displayed in the grid be able to click on the datarow header and that rows data is displayed in 5 textbox below the grid.
I have the filtering working fine and as long as i do not select a category from my combobox when i click on a row the data is displayed in the text boxes below the grid.
PROBLEM: when i select the category which applys afilter to the dataset i can not click on a grid row and get any data
Private Sub cboCategory_SelectedIndexChanged1(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboCategory.SelectedIndexChanged
Dim sCategory As String
Dim dvmsdn As DataView
sCategory = cboCategory.Text
sCategory = "'" + sCategory + "'"
FilterData(dsMsdn1, sCategory)
End Sub