How remove columns from ADO.NET DataTable?

[Ronald S. Cook]

I have an ADO.NET DataTable with several columns. I would like to remove
some columns. How can I do this. please?

[Ronald S. Cook]

Actually, removing the columns is easy. It's that the when I assign one
datatable to another and then remove columns, it seems ot afect BOTH
datatables.

tblHistoryForChart = tblHistoryForGrid

tblHistoryForChart.Columns.Remove("Col1")

tblHistoryForChart.Columns.Remove("Col4")

tblHistoryForChart.Columns.Remove("Col6")

Thanks.

"Ronald S. Cook" <rc***@westinis.com> wrote in message
news:eo**************@TK2MSFTNGP12.phx.gbl...

I have an ADO.NET DataTable with several columns. I would like to remove
some columns. How can I do this. please?

[Ronald S. Cook]

Nevermind. tbl.Copy() was the way to go.

"Ronald S. Cook" <rc***@westinis.com> wrote in message
news:eY**************@TK2MSFTNGP09.phx.gbl...

Actually, removing the columns is easy. It's that the when I assign one
datatable to another and then remove columns, it seems ot afect BOTH
datatables.

tblHistoryForChart = tblHistoryForGrid

tblHistoryForChart.Columns.Remove("Col1")

tblHistoryForChart.Columns.Remove("Col4")

tblHistoryForChart.Columns.Remove("Col6")

Thanks.

"Ronald S. Cook" <rc***@westinis.com> wrote in message
news:eo**************@TK2MSFTNGP12.phx.gbl...

I have an ADO.NET DataTable with several columns. I would like to remove
some columns. How can I do this. please?

[Jason Hales]

Don't forget that you're working with object references.
Your line tblHistoryForChart = tblHistoryForGrid means that both the
variables are pointing to the same memory location, so updating any
properties/ calling any methods on either will indeed affect both
variables