Cursor Adapter with multi select
<p>I've written an APP the uses has a small SQL lite DB and using a cursor adapter I can retrieve the records and populate a list view with them. from there I can get the Id of a selected item and delete it from the DB which works great. the issue I have is that as the DB grows deleting one row at a time would be slow and frustrating so I wanted to know if there was any way to allow multiple selections possibly with check boxes or by even changing the text color of the items selected so that I can retreiving their relative ID's.</p>

<p>I have read some posts that talk about custom cursor adapters but I am not sure how to adapt them to my code. I have posted my code below.</p>

<pre><code>enter code here    private void fillData() {
    Cursor c = mDbHelper.fetchAllNotes();
    startManagingCursor(c);

    String[] from = new String[] {DBHelper.KEY_FIELD0, 
                            DBHelper.KEY_FIELD1,
                            DBHelper.KEY_FIELD2,
                            DBHelper.KEY_FIELD3,
                            DBHelper.KEY_FIELD4};
    int[] to = new int[] {R.id.text,R.id.text2,R.id.text3,R.id.text4,R.id.text5};
    SimpleCursorAdapter dblist = new SimpleCursorAdapter(this, R.layout.row, c, from, to);                                                                                               
    setListAdapter(dblist);   
}
</code></pre>

<p>Thanks.</p>
