select certain columns of a data table

Question

I have a datatable and would like to know if its possible for me to select certain columns and input the data on a table. the columns are set out as below

|col1 |col2 |col3|col4 |col5 |col6|col7 |col8 |col9 |col10 |col11 |

I want to select column col1, col2 col6, col7,col3. and dispay the data in a gridview of the rows within the datatable.. currently the code that i am using is below and onmly selects certain data. I am not selecting the data from sql its data being selected from another excel which is stored in a datatable.. but i am in need of the other columns in another area as well.. this data is being written into a table in word

 for (int i = 1; i < table.Rows.Count; i++)             {                 for (int j = 0; j < table.Columns.Count; j++)                 {                     if (j == 0)                     {                         val = filteredData.Rows[row][col].ToString();                     }                     else                     {                         val = filteredData.Rows[row][col].ToString();                          if (val == "-" || val == "")                         {                             val = filteredData.Rows[row][col].ToString();                          }                         else                         {                             val = Convert.ToString(Math.Round(Convert.ToDouble(filteredData.Rows[row][col]), MidpointRounding.AwayFromZero));                          }                     }                      table[j, i].TextFrame.Text = val;                     col++;                 } 

Answer 1

Also we can try like this,

 string[] selectedColumns = new[] { "Column1","Column2"};   DataTable dt= new DataView(fromDataTable).ToTable(false, selectedColumns);