title: Delete a row from SQLite database by taking id from the populated listview
body: <p>Individual rows in the database are populated in a custom listview. the id of the row is also displayed in the listview. All I want is to delete a particular row by clicking on the corresponding list.</p>
  
  <p>Here is the code I used to display the contents of the database:</p>
  
  <pre><code>class NoteAdapter extends CursorAdapter {
  
      public NoteAdapter(Cursor c) {
          super(Reccuring.this, c);
  
      }
  
      @Override
      public void bindView(View row, Context ctxt, Cursor c) {
          NoteHolder holder = (NoteHolder) row.getTag();
          holder.populateFrom(c, helper);
  
      }
  
      @Override
      public View newView(Context ctxt, Cursor c, ViewGroup parent) {
          LayoutInflater inflater = getLayoutInflater();
          View row = inflater.inflate(R.layout.row1, parent, false);
          NoteHolder holder = new NoteHolder(row);
          row.setTag(holder);
          return row;
      }
  }
  
  static class NoteHolder {
      private TextView name = null;
      private TextView number = null;
      private TextView idtext = null;
  
      NoteHolder(View row) {
          name = (TextView) row.findViewById(R.id.noteText);
          number= (TextView) row.findViewById(R.id.noteText1);
          idtext = (TextView) row.findViewById(R.id.noteText3);
  
      }
  
      void populateFrom(Cursor c, NoteHelper helper) {
          name.setText(helper.getNote(c));
          number.setText(helper.getNote1(c));
          idtext.setText(helper.getNote2(c));
  
      }
  }
  </code></pre>
  
  <p>And here's my database:</p>
  
  <pre><code>public class NoteHelper extends SQLiteOpenHelper {
  
      private static final String DATABASE_NAME = "Test.db";
      private static final int SCHEMA_VERSION = 1;
  
      public NoteHelper(Context context) {
          super(context, DATABASE_NAME, null, SCHEMA_VERSION);
  
      }
  
      @Override
      public void onCreate(SQLiteDatabase db) {
          db.execSQL("CREATE TABLE Notes (_id INTEGER PRIMARY KEY AUTOINCREMENT, note TEXT, num TEXT, sDate TEXT);");
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}
  
      public void insert(String note, String amt, String sDate) {
          ContentValues cv = new ContentValues();
          cv.put("note", note);
          cv.put("num", num);
          cv.put("sDate", sDate);
          getWritableDatabase().insert("Notes", "notes", cv);
      }
  
      public String getNote(Cursor c) {
          return (c.getString(1));
  
      }
  
      public String getNote1(Cursor c) {
          return (c.getString(2));
  
      }
  
      public String getNote2(Cursor c) {
          return (c.getString(0));
  
      }
  
  
  
      public Cursor getAll() {
          return (getReadableDatabase().rawQuery(
                  "SELECT _id, note, num, sDate FROM Notes", null));
  
          }
  
      }
  }
  </code></pre>
  
  <p>How can I select the rows in the listview and delete the corresponding rows in the database. </p>