Selected columns from DataTable

Question

How to get the Selected columns form the DataTable?
For e.g my BaseTable has three columns,
ColumnA,
ColumnB and
ColumnC.

Now as part of intermediate operations, I need to retrieve all the rows only from the ColumnA. Is there any predefined formula just like DataTable.Select?

Answer 1

DataView.ToTable Method.

DataView view = new DataView(MyDataTable);
DataTable distinctValues = view.ToTable(true, "ColumnA");

Now you can select.

DataRow[] myRows = distinctValues.Select();