select column from datatable and convert this to datatable again

Question

I want to select one column in an DataTable in C#, this column should be transform also in an DataTable.

This is what I want.

DataTable(many columns) > select one column > convert this column to a DataTable again

I have try this, but this give me the complete DataTable back.

DataTable dt = defindedDataTable.Columns[0].Table;

Answer 1

You can get the DataView from your table and then use the DataView.ToTable Method. With this method, you can select one or more column you want:

DataTable dt = defindedDataTable.DefaultView.ToTable(false, defindedDataTable.Columns[0].ColumnName);