title: Inserting values to SQLite table in Android
body: <p>I am new in android app developement. I tried to insert values to SQLite database through the below code;</p>
  
  <pre><code>public class cashbook extends Activity {
  
      @Override
      public void onCreate(Bundle savedInstanceState) {
  
          super.onCreate(savedInstanceState);
          setContentView(R.layout.main);
          SQLiteDatabase db;
  
          db = openOrCreateDatabase(
              "cashbookdata.db"
              , SQLiteDatabase.CREATE_IF_NECESSARY
              , null
              );
  
          final String Create_CashBook =
              "CREATE TABLE CashData ("
              + "id INTEGER PRIMARY KEY AUTOINCREMENT,"
              + "Description TEXT," 
              + "Amount REAL,"
              + "Trans INTEGER," 
              + "EntryDate TEXT);";
  
          db.execSQL(Create_CashBook);  
          final String Insert_Data="INSERT INTO CashData VALUES(2,'Electricity',500,1,'04/06/2011')";
          db.execSQL(Insert_Data);
  </code></pre>
  
  <p>It shows error on emulator -  The application CashBook has stopped unexpectedly.</p>
  
  <p>The database and table created , but the value insertion is not working.
  Please help me to resolve this issue.
  Thanks.</p>