title: SQLite and delete command
body: <pre><code>        bool ret = false;
          try
          {
              SQLiteConnection sqlConn = new SQLiteConnection("Data Source=" + m_dbName);
              sqlConn.Open();
              SQLiteCommand sqlComm = sqlConn.CreateCommand();
              sqlComm.CommandText = "DELETE FROM " + szTablename+" WHERE name="+name+"";            
  
              SQLiteDataAdapter sqlAdapter = new SQLiteDataAdapter(sqlComm);
  
              if (null == sqlAdapter)
              {
                  ret = false;
              }
              else
              {
                  ret = true;
              }
              sqlConn.Close();
              return ret;
          }
          catch (SQLiteException sqlEx)
          {
              Console.WriteLine(sqlEx.Message);
              return false ;
          }
  </code></pre>
  
  <p>I have that code to delete a row in an sqlite database, but nothing is done after I click the delete button.                                                                                                                                                                                      </p>