Displaying database table data in Android

Question

I am trying to get the data from SQLite database and display it in a table format in Android. Here is the code for displaying data:

    Cursor c=db.getAllTitles();
    if(c.moveToFirst())
    {
        do
        {
            DisplayTitle(c);
        }while(c.moveToNext());
    }

And the DisplayTitle function looks as shown below:

public void DisplayTitle(Cursor c)
{   
    txt.setText(c.getString(0));
    txt.setTextColor(Color.blue(1));

    tr.addView(txt);
    tl.addView(tr);
}

Here, txt is a TextView variable that I have globally declared in the class. tl is the TableLayout variable and tr is TableRow variable that I have declared globally in the class.

This doesn't work. However, if I use Toast function, the data pulled from the database is getting displayed. Please help.

Here is the link to the entire code:

http://pastebin.me/24d7e33ce334e56087dcb657081684e9

Folks could probably guess what the layout xml looks like, but how about you show yours, just the same? — Thane Anthem
– Thane Anthem, Commented Apr 7, 2011 at 20:47

Thane Anthem · Accepted Answer · 2011-04-07 19:45:36Z

1

My guess is that for each data record you need to declare a new table row with a new text view. From the explanation, it doesn't seem that you want to use the same table row and same text view for all data records.

If you're still stuck, please post a more complete code example. Preferably so complete that others can replicate your problem. Also, please explain what "This doesnt work" means.

answered Apr 7, 2011 at 19:45

Thane Anthem

4,0934 gold badges29 silver badges24 bronze badges

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

2 Comments

CuriousCoder Over a year ago

pastebin.me/24d7e33ce334e56087dcb657081684e9 .. Pls view the complete code here.... IT doesnt work means that i get the "Your application stopped working unexpectedly" error message ...

Thane Anthem Over a year ago

Did you make the change I suggested? Are you still having a problem? Are you able to post the complete code, including the layout XML and the Manifest, as requested?

kkarsko · Accepted Answer · 2013-03-10 15:49:30Z

0

try this code...

public Cursor getAll()  
{
   return db.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_NAME,
   KEY_MOVES, KEY_TIME}, null, null, null, null, null);
}

after that use this code in main activity

private void getall()  
{

   db.open();

   Cursor c = db.SortAllRows();
   int i=1;
   if (c.moveToFirst())   
   {        
      do
      {
         DisplayContact(c,i++);
      } while (c.moveToNext());
   }
   c.close();
   db.close();
}

public void DisplayContact(Cursor c,int row )   
{            
 String name11 = c.getString(1) + c.getString(2) + c.getString(3);           
 tv1.setText(name11 );
}

edited Mar 10, 2013 at 15:49

kkarsko

1231 silver badge7 bronze badges

answered Oct 23, 2012 at 4:54

Durgpal Singh

12k4 gold badges40 silver badges52 bronze badges

Collectives™ on Stack Overflow

Displaying database table data in Android

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related