dataTable.DefaultView.Rowfilter always returning first row

Aya desarrollos picture Aya desarrollos · Jun 7, 2013 · Viewed 21.9k times · Source

I've been trying to make a search function for a dataTable. My problem is that the first row of the table is ALWAYS within the filtered rows, even when the boolean column is actually changed to a zero. Here is my search code:

private void buscar()
    {
        DataTable dataTable;
        if (!verTodos)
        {
            dataTable = DBHelper.Instance.ProductosConStock();
        }
        else
        {
            dataTable = DBHelper.Instance.ProductosTodos();
        }
        dataGridProductos.DataSource = dataTable.DefaultView;
        foreach (DataGridViewRow row in dataGridProductos.Rows)
        {
            if (row.Cells[0].Value.ToString().ToUpper().Contains(txtBusqueda.Text.ToString().ToUpper()) ||
                row.Cells[1].Value.ToString().ToUpper().Contains(txtBusqueda.Text.ToString().ToUpper()) ||
                row.Cells[2].Value.ToString().ToUpper().Contains(txtBusqueda.Text.ToString().ToUpper()))
            {
                row.Cells[4].Value = 1;
            }
            else
            {
                row.Cells[4].Value = 0;
            }
        }
        dataTable.DefaultView.RowFilter = "mostrar = 1";
    }

Answer

CathalMF picture CathalMF · Jun 7, 2013

Try creating a DataView from your datatable and run the filter based on that. Below is a quick example i tried and it works fine.

        DataTable dt = new DataTable();

        dt.Columns.Add("bool", typeof(Boolean));

        dt.Rows.Add(true);
        dt.Rows.Add(false);
        dt.Rows.Add(true);

        DataView dv = new DataView(dt);

        dv.RowFilter = "bool = 1";

        foreach (DataRowView drv in dv)
        {
            Console.WriteLine(drv[0].ToString());
        }