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