Filtering a empty string in DataTable

c# datatable dataview rowfilter
Sankarann picture Sankarann · Jul 10, 2013 · Viewed 13.6k times · Source

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

Microsoft DN picture Microsoft DN · Jul 10, 2013

To filter a dataTable- 

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

To Filter datatview-

dv.RowFilter = "customer_name = ''";

Related questions

How to get data after DataView filtering?

I apply a filter to Dataview and after that I need to get the filtered data. before filtering I did: dvUnloadOpenAccounts.RowFilter = "uso_id = '30640'"; foreach (DataRow row in dvUnloadOpenAccounts.Table.Rows) { HSSFRow dataRow = sheet.CreateRow(rowIndex); foreach (DataColumn …

Read More
Easiest way to copy a dataview to a datatable in C#?

I need to copy a dataview into a datatable. It seems like the only way to do so is to iterate through the dataview item by item and copy over to a datatable. There has to be a better way.

Read More
How to bind dataGridView predefined columns with columns from sql statement (without adding new columns)?

Is there a elegant way, to bind predefined dataGridView columns with results from a SQL statement? Example: dataGridView1.Columns.Add("EID", "ID"); dataGridView1.Columns.Add("FName", "FirstName"); Some SQL like SELECT t.FirstName AS FName, t.EmpID AS EID FROM …

Read More