How to get data from database in my android table view as columns

Question

I have done following coding for deriving data's from table and displayed in the android view as a Table columns and rows.

The Database coding is

public List<Country> getAllCountry()
{
    List<Country> countryList = new ArrayList<Country>();

    //select query
    String selectQuery = "SELECT * FROM COUNTRY_LIST";

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);


    for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext())
    {
         Country country = new Country();
            country.setId(cursor.getString(0));
            country.setName(cursor.getString(1));
            country.setNationalty(cursor.getString(2));
            country.setDate(cursor.getString(3));


            // Adding person to list
            countryList.add(country);
    }

    return countryList;

}

The XML is

<TableLayout 
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:id="@+id/tab">
  <TableRow
      >        
  </TableRow>    
</TableLayout>

The Activity Coding is

List<Country> country = db.getAllCountry();

    StringBuilder builder = new StringBuilder();
    for (Country c: country)
    {               
        builder.append(c.getId()).append(";")
            .append(c.getName()).append(";")
            .append(c.getNationalty()).append(";")
            .append(c.getDate()).append("_");
    }
    //tv.setText(builder.toString());

    builder.toString();

    String st = new String(builder);
    Log.d("Main",st);
    String[] rows  = st.split("_");
    TableLayout tableLayout = (TableLayout)findViewById(R.id.tab);
    tableLayout.removeAllViews();

    for(int i=0;i<rows.length;i++){
        Log.d("Rows",rows[i]);
        String row  = rows[i];
        TableRow tableRow = new TableRow(getApplicationContext());
        tableRow.setLayoutParams(new TableLayout.LayoutParams(LayoutParams.MATCH_PARENT, LayoutParams.WRAP_CONTENT));
        final String[] cols = row.split(";");

        Handler handler = null;

        for (int j = 0; j < cols.length; j++) {             
            final String col = cols[j];                                 
            TextView columsView = new TextView(getApplicationContext());
            columsView.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT, TableRow.LayoutParams.WRAP_CONTENT));
            columsView.setTextColor(color.black);
            columsView.setText(String.format("%7s", col));                                
            Log.d("Cols", String.format("%7s", col));
            tableRow.addView(columsView);

        }
    }

The above code not printing anything in the android emulator screen.

Please say what have I done wrong.

Thanks in advance.

Regards, Dinesh

are you able to print log of your record?

Manish Srivastava
– Manish Srivastava

2013-08-01 07:04:48 +00:00
Commented Aug 1, 2013 at 7:04 — Manish Srivastava
– Manish Srivastava, Commented Aug 1, 2013 at 7:04

Vedang Jadhav · Accepted Answer · 2013-08-01 07:28:50Z

1

I guess you are missing tableLayout.addView(tableRow) on the last line of the 1st for loop after coming out of 2nd for loop..else row will not be added..

answered Aug 1, 2013 at 7:28

Vedang Jadhav

5102 silver badges11 bronze badges

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

Comments

Simon Dorociak · Accepted Answer · 2013-08-01 07:05:05Z

0

I think you most likely forgot to call this method:

setContentView(<yourLayout>);

that will set layout for your Activity.

Note: Don't forget to test whether your List is empty or not to be sure you have data.

answered Aug 1, 2013 at 7:05

Simon Dorociak

33.5k10 gold badges70 silver badges107 bronze badges

1 Comment

MKD Over a year ago

Hi, Sajmon Thanks for your reply. I have tried by using it. I showing the below error "java.lang.IllegalStateException: The specified child already has a parent. You must call removeView() on the child's parent first." Can you suggest any other idea?

Collectives™ on Stack Overflow

How to get data from database in my android table view as columns

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related