Search data from a Gridview or Dataset.

[geek648]

You could have another datatable and when the Search Text changes, copy the matching rows from the original to the shown datatable (or just unhook the DGV from the original dt and manually fill it each time.
Or set unmatched rows to visible=false in the DGV, if that's possible.

[jmcilhinney]

You could have another datatable and when the Search Text changes, copy the matching rows from the original to the shown datatable (or just unhook the DGV from the original dt and manually fill it each time.
Or set unmatched rows to visible=false in the DGV, if that's possible.

Definitely don't do that.

The proper way to do this is via a BindingSource. Populate your DataTable, bind that to a BindingSource and then bind that to the DataGridView (NOT GridView, which is a different control altogether). To filter the data, simply set the Filter property of the BindingSource, e.g.

myBindingSource.Filter = String.Format("SomeColumn LIKE '{0}%'", myTextBox.Text)

[harsh288]

Hello jmcilhinney,

You 're simply genius, that resolved and that too with the most effective solution.
Thanks a lot

[geek648]

Definitely don't do that.

The proper way to do this is via a BindingSource.

Well at least I can serve as an example of how not to do it, LOL.
I'll get my coat.

Thanks for educating me

[jmcilhinney]

Well at least I can serve as an example of how not to do it, LOL.
I'll get my coat.

Thanks for educating me

Getting it wrong is usually the first step on the road to getting it right.