title: Fill ComboBox with Access DB data
body: <p>I'm using Visual Studio 2010 and C# to create a windows form with a combobox that should contain employees initials. I have spent the last few days searching through every solution I can find and I still can not get my combobox to populate. </p>
  
  <p>This is what I've got as of now:</p>
  
  <pre><code>public static void FillComboBox(string Query, System.Windows.Forms.ComboBox LoggedByBox)
  {
      using (var CONN = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\Documents\\Service Request Application\\bin\\Debug\\servicereq1.mdb"))
      {
          CONN.Open();
          DataTable dt = new DataTable();
          try
          {
              OleDbCommand cmd = new OleDbCommand(Query, CONN);
              OleDbDataReader myReader = cmd.ExecuteReader();
              dt.Load(myReader);
          }
          catch (OleDbException e)
          {
              Console.WriteLine(e.ToString());
              Console.ReadLine();
  
              return;
          }
          LoggedByBox.DataSource = dt;
          LoggedByBox.ValueMember = "ID";
          LoggedByBox.DisplayMember = "Initials";
      }
  }
  </code></pre>
  
  <p>Then I call it when the form loads</p>
  
  <pre><code>private void Form1_Load(object sender, EventArgs e)
  {
      FillComboBox("select ID, Initials from [Fixers and Testers]", LoggedByBox);
  }
  </code></pre>
  
  <p>When I run the program, the combobox is still blank. I'm positive that my column names and table names are correct. Any suggestions?</p>