How to remove datatable column in c#

Question

i have an datatable with 12 columns.now i need to remove all the columns except at the position "0"

i can remove individually by specifying the columns name. but i dnt want to do that.as it is not best way to code.

is there any other i can do that

thanks

Answer 1

Go backwards through the columns and remove each one. You have to go backwards to avoid an index out of range exception.

// index should include zero
for( int index=table.Columns.Count-1; index>=0; index-- )
{
   table.Columns.RemoveAt( index );
}

VB.Net Lovers:

'index should include zero
For index As Integer = table.Columns.Count - 1 To 0 Step -1
    table.Columns.RemoveAt(index)
Next