Removing columns with row values from a data table

Question

I want to remove a specific column from my datable before limiting it to the grid view. I tried with

finalTable.Columns.RemoveAt(0);
finalTable.Columns.RemoveAt(1);

but it does not delete the row values that belong to that column.

How can I delete a column with row values?

EDIT: After it's anchored to the grid, the rows are displayed in the third column.

+2

Royson May 03 '10 at 10:55

2 answers

THE DOCTOR · Answer 1 · 2010-05-03T15:34:34+0000

try:

 DataTable example; 
       example.Columns.Remove("columnName"); 
       example.Columns.RemoveAt(columnIndex);

Amsakanna · Answer 2 · 2010-05-03T11:07:48+0000

Try the following:

If(finalTable.Columns.CanRemove(finalTable.Columns[0]))
{
    finalTable.Columns.RemoveAt(0); 
}

finalTable.AcceptChanges()

Then bind it using gridview

Removing columns with row values ​​from a data table