title: select certain columns of a data table
body: <p>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</p>
  
  <p>|col1 |col2 |col3|col4 |col5 |col6|col7 |col8 |col9 |col10 |col11 |</p>
  
  <p>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</p>
  
  <pre><code> for (int i = 1; i &lt; table.Rows.Count; i++)
              {
                  for (int j = 0; j &lt; 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++;
                  }
  </code></pre>