Get all records from SQLite in ANDROID

  String[] coloumns = new String[] { KEY_ROWID, KEY_NAME,KEY_NICKNAME }; // calling  all  elements in an array
  Cursor c = db.query(DATABASE_TABLE, coloumns, null, null, null, null,null);// basically reading a database need cursor
  String result = " ";// since string is to be returned
  System.out.println("count of cursor=====>>" + c.getCount());

  int iRowid = c.getColumnIndex(KEY_ROWID);
                // calling each row values
  int iRowName = c.getColumnIndex(KEY_NAME);
  int iRowNickName = c.getColumnIndex(KEY_NICKNAME);
  
     if (c.moveToFirst()) {
         c.moveToFirst();
          for (int i = 0; i < c.getCount(); i++) {result
                      = result + c.getString(iRowid) + " "
                      + c.getString(iRowName) + " "
                      + c.getString(iRowNickName) + "\n";
     System.out.println(result + " <> " + iRowid + " <> "+ iRowName);
         c.moveToNext();
            }
        }
        c.close();
        db.close();
        return result;

       TextView infotext=(TextView) findViewById(R.id.tvsqlinfo);
       DBAdapter info = new DBAdapter(this);
       info.open();
       String data =info.getdata();
       System.out.println("result is ==========>>" + data);
       info.close();
       infotext.setText(data);
       infotext.setTextColor(Color.RED);