Filtering a empty string in DataTable

Question

How do filter a empty String in DataTable?

I need to filter a column (say Customer Name where the name is string.Empty)

I tried this but i cant get into right way..

I need to filter the DataView through DataView.RowFilter.. so how to give filter string for string.Empty..

Any idea on this?

Answer 1

To filter a dataTable-

dt.Select("customer_name = ''"); 

To Filter datatview-

dv.RowFilter = "customer_name = ''";

Answer 2

Use Select method:

DataRow[] foundRows = dt.Select("MyColumn = ''");