Hi,

Two questions using VB.NET and ADO .NET

What is the best way to remove/delete a datacolumn from a datatable (without
using a dataview).
What is the best way to re-order columns in a datatable.

Many thanks.

Q1: DataTable.Columns.Remove(index)

Q2: DataView

"11Oppidan" <(E-Mail Removed)> wrote in message
news:%23rg%23Jl$(E-Mail Removed)...
> Hi,
>
> Two questions using VB.NET and ADO .NET
>
> What is the best way to remove/delete a datacolumn from a datatable
> (without using a dataview).
> What is the best way to re-order columns in a datatable.
>
> Many thanks.
>

Thanks for Scotts's quick response.

Hi 11Oppidan,

DataTable.Columns.Remove takes the column name or column reference as
argument. To remove column using it's index, you can use
DataTable.Columns.RemoveAt method.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

thanks guys!


"Kevin Yu [MSFT]" <v-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for Scotts's quick response.
>
> Hi 11Oppidan,
>
> DataTable.Columns.Remove takes the column name or column reference as
> argument. To remove column using it's index, you can use
> DataTable.Columns.RemoveAt method.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>

You're welcome.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."