Retrieving column names with column values in sqlite using cursor

Question

I want to display column names with column values in the Listview using cursor. My present code shows only the column values.

public void openAndQueryDatabase() {

    db = openOrCreateDatabase( "mydatabase.db", SQLiteDatabase.CREATE_IF_NECESSARY , null ); 

    Cursor cursor = db.rawQuery("select * from "+ table + " where name='"+ name + "'",  null);


    int count = cursor.getColumnCount();

    if (cursor!=null )
    { 

        if  (cursor.moveToFirst())
        {
            do 
            {
                 for (int i =0 ; i< count; i++)
                {
                String data = cursor.getString(i);
                details.add(data);
                }
            } 
            while (cursor.moveToNext()); 
        } 

         }
}

You don't really need to do a rawquery, you could just use the wrapper methods. — jtt
– jtt, Commented Apr 19, 2014 at 8:39

diedthreetimes · Accepted Answer · 2016-06-15 23:04:24Z

2

In this case you should use hashmap

for (int i =0 ; i< count; i++)
{
    String data = cursor.getString(i);
    String column_name = cursor.getColumnName(i);

    HashMap<String,String> map = new HashMap<String,String>();
    map.put("column_value",data);
    map.put("column_name",column_name);

    details.add(map); //change the type of details from ArrayList<String> to arrayList<HashMap<String,String>>
}

edited Jun 15, 2016 at 23:04

diedthreetimes

4,13328 silver badges39 bronze badges

answered Apr 19, 2014 at 8:47

Sunny Garg

1,0731 gold badge6 silver badges14 bronze badges

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

2 Comments

Shayan Pourvatan Over a year ago

you should edit your post instead of add another answer

Sunny Garg Over a year ago

this site allows to answer more than once. Right? therefore i did that.

Gabe Sechan · Accepted Answer · 2014-04-19 08:36:23Z

2

Use getColumnName(int columnIndex) to get the name of the row for a given index.

answered Apr 19, 2014 at 8:36

Gabe Sechan

94.7k9 gold badges92 silver badges135 bronze badges

1 Comment

pskink Over a year ago

one liner: DatabaseUtils.cursorRowToContentValues

Gowthaman M · Accepted Answer · 2018-04-25 12:07:28Z

1

Use this.

 for (int i =0 ; i< count; i++)
  {
      String data = cursor.getString(i);
      String column_name = cursor.getColumName(i);
      details.add(data);
  }

edited Apr 25, 2018 at 12:07

Gowthaman M

8,3029 gold badges40 silver badges57 bronze badges

answered Apr 19, 2014 at 8:38

Sunny Garg

1,0731 gold badge6 silver badges14 bronze badges

1 Comment

PrachiN Over a year ago

This will add only column values to the listview. How to display both of them together?

Oleksandr Nos · Accepted Answer · 2016-08-01 11:28:55Z

0

Simply retrieve String array with names like that:

cursor.getColumnNames()

answered Aug 1, 2016 at 11:28

Oleksandr Nos

6171 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

Retrieving column names with column values in sqlite using cursor

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related