title: DataSet Select Column
body: <p>I would like to select a specific column from a Dataset once it's been populated (e.g. Column Grades)  and put the values into a list</p>
  
  <pre><code>string excelFile = @"C:\Scores.xlsx";
  if (File.Exists(excelFile))
  {
      string connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+excelFile+";Extended Properties=Excel 12.0;";
      var dataAdapter = new OleDbDataAdapter();
      var objConn = new OleDbConnection(connString);
  
      //SELECT [Name],[Grade],[Location] ect...
      const string query = "SELECT * FROM [TeamScores$]"; 
      var objCmd = new OleDbCommand(query, objConn);
  
      var table = new DataSet();
      dataAdapter.SelectCommand = objCmd;
      dataAdapter.Fill(table);               
  
      //I would like to filter the DataSet to select only [Name] and populate the values into a List&lt;string&gt;
  
      dataGridView1.DataSource = table.Tables[0]; //Will show all results                
  
  }
  </code></pre>