How to display the data in table view in android eclipse

Question

public void Showdata(View view)
    {
        Cursor c = db.rawQuery("SELECT * FROM Student2", null);
        int count = c.getCount();
        c.moveToFirst();
        TableLayout tablelayout = new TableLayout(getApplicationContext());
        tablelayout.setVerticalScrollBarEnabled(true);
        TableRow tablerow;
        TextView textview, textview1, textview3, textview5;
        tablerow = new TableRow(getApplicationContext());

        textview = new TextView(getApplicationContext());
        textview.setText("Name");
        textview.setTextColor(Color.RED);
        textview.setTypeface(null, Typeface.BOLD);
        textview.setPadding(20, 20, 20, 20);
        tablerow.addView(textview);


        textview5 = new TextView(getApplicationContext());
        textview5.setText("Email");
        textview5.setTextColor(Color.RED);
        textview5.setTypeface(null, Typeface.BOLD);
        textview5.setPadding(20, 20, 20, 20);
        tablerow.addView(textview5);
        tablelayout.addView(tablerow);

        for(Integer j=0; j< count; j++)
        {
            tablerow = new TableRow(getApplicationContext());

            textview1 = new TextView(getApplicationContext());
            textview1.setText(c.getString(c.getColumnIndex(name)));


            textview3 = new TextView(getApplicationContext());
            textview3.setText(c.getString(c.getColumnIndex(email)));

            textview1.setPadding(20, 20, 20, 20);
            textview3.setPadding(20, 20, 20, 20);

            tablerow.addView(textview1);
            tablerow.addView(textview3);

            tablelayout.addView(tablerow);
            c.moveToNext();
        }
        setContentView(tablelayout);
        db.close();
    }

Answer 1

I've tested your code with some dummy students, it is working fine for me.

Please verify that you are getting students by iterating the cursor. Put some Log.d("tag","some_student") for testing

Also, You should use YourActivityName.this in place of getApplicationContext(). For example

tablerow = new TableRow(this);

Full Code using the dummy students

import android.app.Activity;
import android.graphics.Color;
import android.graphics.Typeface;
import android.os.Bundle;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;

import java.util.ArrayList;
import java.util.List;

public class MainActivity extends Activity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        List<Student> students = new ArrayList<>();
        students.add(new Student("Rahul","rahul@gmail.com"));
        students.add(new Student("Shweta","shweta@gmail.com"));
        students.add(new Student("Test","test@gmail.com"));
        students.add(new Student("Mohan","mohan@gmail.com"));


        TableLayout tablelayout = new TableLayout(this);
        tablelayout.setVerticalScrollBarEnabled(true);
        TableRow tablerow;
        TextView textview, textview1, textview3, textview5;
        tablerow = new TableRow(this);

        textview = new TextView(this);
        textview.setText("Name");
        textview.setTextColor(Color.RED);
        textview.setTypeface(null, Typeface.BOLD);
        textview.setPadding(20, 20, 20, 20);
        tablerow.addView(textview);


        textview5 = new TextView(this);
        textview5.setText("Email");
        textview5.setTextColor(Color.RED);
        textview5.setTypeface(null, Typeface.BOLD);
        textview5.setPadding(20, 20, 20, 20);
        tablerow.addView(textview5);
        tablelayout.addView(tablerow);

        for(Integer j=0; j< students.size(); j++)
        {
            tablerow = new TableRow(this);

            textview1 = new TextView(this);
            textview1.setText(students.get(j).getName());


            textview3 = new TextView(this);
            textview3.setText(students.get(j).getEmail());

            textview1.setPadding(20, 20, 20, 20);
            textview3.setPadding(20, 20, 20, 20);

            tablerow.addView(textview1);
            tablerow.addView(textview3);

            tablelayout.addView(tablerow);
        }
        setContentView(tablelayout);

    }

    class Student {
        String name;
        String email;

        public Student(String name, String email) {
            this.name = name;
            this.email = email;
        }

        public String getName() {
            return name;
        }

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

        public String getEmail() {
            return email;
        }

        public void setEmail(String email) {
            this.email = email;
        }
    }
}