title: Need help on deleting row(s) from a SQL Server CE database
body: <p>Another question today. This time, I'm having trouble deleting a row from a SQL Server CE database.</p>
  
  <pre><code>private void Form1_Load(object sender, EventArgs e)
  {
          // Create a connection to the file datafile.sdf in the program folder
          string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\\userDtbs.sdf";
          SqlCeConnection connection = new SqlCeConnection("datasource=" + dbfile);
  
          // Read all rows from the table test_table into a dataset (note, the adapter automatically opens the connection)
          SqlCeDataAdapter adapter = new SqlCeDataAdapter("SELECT * FROM history", connection);
          DataSet data = new DataSet();
          adapter.Fill(data);
  
          //Delete from the database
          using (SqlCeCommand com = new SqlCeCommand("DELETE FROM accounts WHERE Id = 0", connection))
          {
              com.ExecuteNonQuery();
          }
  
          // Save data back to the databasefile
          var cmd = new SqlCeCommandBuilder(adapter);
          adapter.Update(data);
  
          // Close 
          connection.Close();
  }
  </code></pre>
  
  <p>My program's giving me an error telling me that <code>connection</code> is in a closed state, and I can't figure out why it would close before the <code>DELETE</code> command is executed.</p>