Database add item to list view?

Question

I download this database script and i was wondering how can i convert it to instead add a item to a list view.. its a really easy understandable database code..

http://www.anotherandroidblog.com/wp-content/uploads/2010/08/AABDatabase.zip

Thats the source for it..

also im guessing it could be in here??

/**
 * retrieves a row from the database with the id number in the corresponding
 * user entry field
 */
private void retrieveRow()
{
    try
    {
        // The ArrayList that holds the row data
        ArrayList<Object> row;
        // ask the database manager to retrieve the row with the given rowID
        row = db.getRowAsArray(Long.parseLong(updateIDField.getText().toString()));

        // update the form fields to hold the retrieved data
        updateTextFieldOne.setText((String)row.get(1));
        updateTextFieldTwo.setText((String)row.get(2));
    }
    catch (Exception e)
    {
        Log.e("Retrieve Error", e.toString());
        e.printStackTrace();
    }
}

Lalit Poptani · Accepted Answer · 2011-09-26 05:42:02Z

1

To add the items from database to a ListView you can have an ArrayList

1.) ArrayList<String> arrList = new ArrayList<String>();

2.) Fetch items from database and add them to ArrayList

        if(c.getCount() > 0){
            c.moveToFirst();
            for (int i = 0; i < c.getCount() - 1; i++) {
                arrList.add(c.getString(0));
                c.moveToNext();
            }

3.) Then populate the Adapter with the ArrayList(arrList).

4.) And fill the ListView with the Adapter.

edited Sep 26, 2011 at 5:42

answered Sep 26, 2011 at 5:22

Lalit Poptani

67.3k23 gold badges165 silver badges248 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hailei Edwards Over a year ago

i don't quite understand.. could you send me a modified version of the code

Lalit Poptani Over a year ago

It would be better for you to look at some ListView examples and then try to populate what I have answered. Thanks.

Collectives™ on Stack Overflow

Database add item to list view?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related