Remove a column from gridview

Question

I’m implementing a functionality in a project using Asp.net mvc and I’m trying to remove some columns from a gridview that I created in my application, the gridview datasource is a table in the database, but I want to remove some columns from the table, because I am trying to export this data to an excel file and some table items like the primary key are not required. How do I remove the columns from my gridview choice? I’ve tried things like:

gv.Columns.Remove("ArquivoExcelId");

also tried to:

gv.Columns[0].Visible = false;

but the 2 generated error, as if the past parameters were incomparable or something like, someone knows how to do this?

Answer 1

Try this:

private void BindDataAndInitializeColumns()
{
    dataGridView1.AutoGenerateColumns = true;
    dataGridView1.DataSource = customersDataSet;
    dataGridView1.Columns.Remove("Fax");
    dataGridView1.Columns["CustomerID"].Visible = false;
}

Taken from the MSDN.

Or with the gv.Columns.RemoveAt(x);

Answer 2

Friend, why don’t you filter the column by removing it from the select?

You can also make the change via front-end, by css putting style = "display: none;" in the column.

Another solution via server side is to mount the columns through the RowDataBound. If you prefer, treat Dataset:

gv.Columns.RemoveAt(0); //Index da coluna 'ArquivoExcelId'

Or

gv.Columns.Remove("ArquivoExcelId");