title: How do I find a row ID and delete it from a database & listview?
body: <p>I have a database file with a delete function:</p>
  
  <pre><code>public boolean deleteContact(long rowId) {
      return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) &gt; 0;
  }
  </code></pre>
  
  <p>Inside my List View adapter I have select-able items which give options:</p>
  
  <pre><code>private void Example() {
      AlertDialog.Builder dlgAlert = new AlertDialog.Builder(ShopSell.this);
      dlgAlert.setTitle("Example Item");
      dlgAlert.setMessage("What would you like to do?");
      dlgAlert.setPositiveButton("Okay",
              new DialogInterface.OnClickListener() {
                  public void onClick(DialogInterface dialog, int which) {
  
                      dialog.dismiss();
                  }
              });
      dlgAlert.setNegativeButton("Delete",
              new DialogInterface.OnClickListener() {
                  public void onClick(DialogInterface dialog, int which) {
  //This is where I'm trying to delete the item
                       db.deleteContact(//no idea what to put here...);
  
                  }
              });
      dlgAlert.setCancelable(true);
      dlgAlert.create().show();
  } 
  </code></pre>
  
  <p>so what method do I call to find out the rowID and delete it accordingly?
  <br> Here's the entire Database file if needed:</p>
  
  <pre><code>public class DBAdapter {
  public static final String KEY_ROWID = "_id";
  public static final String KEY_ITEM = "item";
  
  private static final String TAG = "DBAdapter";
  
  private static final String DATABASE_NAME = "InventoryDB";
  private static final String DATABASE_TABLE = "inventory";
  private static final int DATABASE_VERSION = 4;
  
  private static final String DATABASE_CREATE = "create table if not exists inventory (_id integer primary key autoincrement, "
          + "item VARCHAR not null);";
  
  private final Context context;
  
  private DatabaseHelper DBHelper;
  private static SQLiteDatabase db;
  
  public DBAdapter(Context ctx) {
      this.context = ctx;
      DBHelper = new DatabaseHelper(context);
  }
  
  private static class DatabaseHelper extends SQLiteOpenHelper {
      DatabaseHelper(Context context) {
          super(context, DATABASE_NAME, null, DATABASE_VERSION);
      }
  
      @Override
      public void onCreate(SQLiteDatabase db) {
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
                  + newVersion + ", which will destroy all old data");
          db.execSQL("DROP TABLE IF EXISTS inventory");
          onCreate(db);
      }
  }
  
  // ---opens the database---
  public DBAdapter open() throws SQLException {
      db = DBHelper.getWritableDatabase();
      return this;
  }
  
  // ---closes the database---
  public void close() {
      DBHelper.close();
  }
  
  // ---insert a record into the database---
  public long insertRecord(String item) {
      ContentValues initialValues = new ContentValues();
      initialValues.put(KEY_ITEM, item);
      return db.insert(DATABASE_TABLE, null, initialValues);
  }
  
  // ---deletes a particular record---
  public boolean deleteContact(long rowId) {
      return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) &gt; 0;
  }
  
  // ---retrieves all the records---
  public static Cursor getAllRecords() {
      return db.query(DATABASE_TABLE, new String[] { KEY_ROWID, KEY_ITEM},
              null, null, null, null, null, null);
  }
  
  // ---retrieves a particular record---
  public Cursor getRecord(long rowId) throws SQLException {
      Cursor mCursor = db.query(true, DATABASE_TABLE, new String[] {
              KEY_ROWID, KEY_ITEM }, KEY_ROWID + "=" + rowId, null, null,
              null, null, null);
      if (mCursor != null) {
          mCursor.moveToFirst();
      }
      return mCursor;
  }
  
  public int deleteAll(){
      return 0;
  
       }
  
  // ---updates a record---
  public boolean updateRecord(long rowId, String item) {
      ContentValues args = new ContentValues();
      args.put(KEY_ITEM, item);
  
      return db.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) &gt; 0;
  }
  </code></pre>
  
  <p>}</p>