title: How to do a SELECT with multiple columns from an SQLCE database?
body: <p>Because my last question didn't return anything useful, I will have to ask yet another question.</p>
  
  <p>The situation:</p>
  
  <p>I have a local SQLCE database. It contains 2 tables; "Artikels" and "Leggers" (Don't mind the Dutch names, doesn't change the situation). The table I'll be querying has the columns "Artikelnummer", "Omschrijving", "Legger", and "Voorraad".</p>
  
  <p>What I want to do:</p>
  
  <p>Query the table "Artikels" for "Artikelnummer" and "Omschrijving" and then display it in a CheckedListbox, preferably with two seperate columns (or just one if it doesn't work with multiple).</p>
  
  <p>The code I have put together from tutorials and answers here:</p>
  
  <pre><code>private void populateListbox()
      {
          string connectionString = Properties.Settings.Default.Database;
  
          string selectString = "select artikelnummer, omschrijving from Artikels";
  
          SqlCeDataAdapter sqlDataAdapter = new SqlCeDataAdapter();
  
          DataSet dataSet = new DataSet();
  
  
              using (SqlCeConnection connection = new SqlCeConnection(connectionString))
              using (SqlCeCommand query = new SqlCeCommand(selectString, connection))
              {
                  connection.Open();
  
                  string dataTableName = "Artikels";
  
                  sqlDataAdapter.SelectCommand = new SqlCeCommand(selectString);
  
  
                  DataTable dataTable = dataSet.Tables[dataTableName];
  
                  listboxGeselecteerd.DataSource = dataSet.Tables[dataTableName];
                  listboxGeselecteerd.ValueMember = "[Artikelnummer]";
                  listboxGeselecteerd.DisplayMember = "[Omschrijving]"; 
  
                  connection.Close();
              }
  
      }
  </code></pre>
  
  <p>I don't get any errors, but while debugging I have seen that nothing is happening from  <code>DataTable dataTable = dataSet.Tables[dataTableName];</code> on.</p>
  
  <p>I have googled it, but nothing I have read mentioned selecting multiple columns.</p>
  
  <p>I am using VS2010, by the way.</p>