I'll start off by listing the code i have thus far...

This is my main Activity class:

```
public class SQLiteDatabaseMain extends Activity
{
    ListView list;
    DatabaseHelper helper;
    SQLiteDatabase db;
    DatabaseAdapter adapter;

    @Override
    public void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        init();
    }

    public void init()
    {
        helper = new DatabaseHelper(this);

        list = (ListView) findViewById(R.id.listView1);

        db = helper.getWritableDatabase();

        helper.populateGrocery(db);

    }

}

```

This is my DatabaseHelper class:

```
public class DatabaseHelper extends SQLiteOpenHelper
{

private static final String DATABASE_NAME = "grocerystoretest.db";
private static final String DATABASE_TABLE = "grocerystoreitems";
private static final String GROCERY_KEY_NAME = "name";
private static final String GROCERY_KEY_TYPE = "type";
private static final int SCHEMA_VERSION = 1;

SQLiteDatabaseMain sqlMain = new SQLiteDatabaseMain();

public DatabaseHelper(Context context)
{
    super(context, DATABASE_NAME, null, SCHEMA_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db)
{
    db.execSQL("CREATE TABLE "
            + DATABASE_TABLE
            + " (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, type TEXT);");
}

@Override
public void onUpgrade(SQLiteDatabase db, int arg1, int arg2)
{
    // db.execSQL("DROP TABLE IF EXISTS " + DATABASE_NAME);

}

public void insert(String name, String type)
{
    ContentValues cv = new ContentValues();
    cv.put("name", name);
    cv.put("type", type);

    getWritableDatabase().insert(DATABASE_TABLE, "name", cv);
}

public void update(String id, String name, String type)
{
    ContentValues cv = new ContentValues();
    String[] args =
    { id };

    cv.put("name", name);
    cv.put("type", type);

    getWritableDatabase().update(DATABASE_TABLE, cv, "_ID=?", args);
}

public void delete(String id, String name, String type)
{
    ContentValues cv = new ContentValues();
    String[] args =
    { id };

    cv.put("name", name);
    cv.put("type", type);

    getWritableDatabase().delete(DATABASE_TABLE, "_ID=?", args);
}

public void populateGrocery(SQLiteDatabase db)
{
    ArrayList<GroceryObj> groceryArrayList;
    groceryArrayList = buildGroceryArrayList();
    String insertStmt = null;
    for (int i = 0; i < groceryArrayList.size(); i++)
    {
        insertStmt = "INSERT INTO " + DATABASE_TABLE + " ("
                + GROCERY_KEY_NAME + ", " + GROCERY_KEY_TYPE + ") "
                + "VALUES (\"" + groceryArrayList.get(i).getName()
                + "\", \"" + groceryArrayList.get(i).getType() + "\");";
        db.execSQL(insertStmt);
    }
}

private ArrayList<GroceryObj> buildGroceryArrayList()
{
    ArrayList<GroceryObj> aL = new ArrayList<GroceryObj>();
    DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
    try
    {
        Context context;
        context = sqlMain.getApplicationContext();

        DocumentBuilder builder = factory.newDocumentBuilder();
        InputStream raw = context.getAssets().open("default_grocerystore.xml");
        Document dom = builder.parse(raw);
        Element root = (Element) dom.getDocumentElement();
        NodeList groceryItems = ((Document) root)
                .getElementsByTagName("grocery");
        for (int i = 0; i < groceryItems.getLength(); i++)
        {
            String name = null;
            String type = null;
            Node item = groceryItems.item(i);
            NodeList groceryItem = item.getChildNodes();
            for (int j = 0; j < groceryItem.getLength(); j++)
            {
                Node nodeItem = groceryItem.item(j);
                String nodeName = nodeItem.getNodeName();
                if (nodeName.equalsIgnoreCase("name"))
                {
                    name = nodeItem.getFirstChild().getNodeValue();
                } else if (nodeName.equalsIgnoreCase("type"))
                {
                    type = nodeItem.getFirstChild().getNodeValue();
                }
            }
            aL.add(new GroceryObj(name, type));
        }
    } catch (Exception e)
    {
        e.printStackTrace();
    }
    return aL;
}

public String getName(Cursor c)
{
    return (c.getString(1));
}

public String getType(Cursor c)
{
    return (c.getString(3));
}

}

```

This is my GroceryObj class:

```
public class GroceryObj
{

private String name = "";
private String type = "";

public GroceryObj(String name, String type)
{
    this.name = name;
    this.type = type;
}

public String getName()
{
    return (name);
}

public void setName(String name)
{
    this.name = name;
}

public String getType()
{
    return (type);
}

public void setType(String type)
{
    this.type = type;
}

}

```

My DatabaseAdapter class is blank right now. This is what I need to figure out!:

```
public class DatabaseAdapter extends CursorAdapter
{

public DatabaseAdapter(Context context, Cursor c)
{
    super(context, c);
}

@Override
public void bindView(View view, Context context, Cursor cursor)
{

}

@Override
public View newView(Context context, Cursor cursor, ViewGroup parent)
{
    return null;
}

}

```

Then I have an xml file that stores all of the grocery items by name and type:

```
<?xml version="1.0" encoding="utf-8"?>
<default_grocerystore>
    <grocery>
            <name>Bread</name>
            <type>Bakery</type>
    </grocery>
    <grocery>
            <name>Rolls</name>
            <type>Bakery</type>
    </grocery>
    <grocery>
            <name>Juice</name>
            <type>Beverages</type>
    </grocery>
    <grocery>
            <name>Soda</name>
            <type>Beverages</type>
    </grocery>
</default_grocerystore>

```

And finally I have a row.xml that is just two textViews that are to display the name and type of each item in each row of my ListView.

My main.xml is just a TextView and a listview.

What I'm really stuck on is the Adapter. Ive used database adapters before to insert rows into a database via editTexts and a holder object but Ive never just taken a static database and had it converted to each row to View via my listView. Anyone have any pointers on what is needed to get my database viewed via a listView?? Any help would be greatly appreciated because I am completely stumped here. Ive been racking my brain for the past few hours trying to find out how to do this. Thanks for any help!