DATAGRID Search

[ask4jm]

I want to implement a search in Database. The datasource is set to a dataset. When the word is found the entire datarow is selected. I want the selection to be reflect the proper place even when somebody click the caption of the coulumn and changes its sort order.

In my case it remain selecting the specific row even when I change the sort order.

Thanks.