Hide column in data table c#

You can't hide columns in a DataTable, as such.

Even if you create a DataView from the DataTable, you can only filter rows not columns.

What's usually done instead is to hide those columns in the control to which the DataTable is bound

This is what Abhishek has done in his example.

Hi,

DataTable dt = new DataTable();

            dt.Columns.Add("CustomerID");
            dt.Columns.Add("FirstName");

            dt.Columns.Add("Amount");
            dt.Rows.Add("0001", "Abhishek", 10000);
            dt.Rows.Add("0002", "Ram", 20000);
            dt.Rows.Add("0003", "Alice", 30000);
            dt.Rows.Add("0004", "David", 40000);

            Gridview1.DataSource = dt;
            Gridview1.DataBind();

Gridview1.Columns["Amount"].Visible = false;

Hope this helps.

Lakshmanan Sethu Sankaranarayan12y ago

Hi Please check this http://stackoverflow.com/questions/18085271/how-to-hide-column-in-data-table http://stackoverflow.com/questions/13416761/how-to-remove-or-hide-particular-column-in-a-datatable