How To Hide A Column In Database

This is my original code: String sqlQuery = 'SELECT * FROM data where company = ''+ Selecteditem +''' ; SQLiteDatabase db = this.getWritableDatabase(); Cursor c = db.rawQuery(sql

Solution 1:

You can just remove the company string, by replacing c.getString(c.getColumnIndex("company")) with an empty string "".

StringsqlQuery="SELECT * FROM data where company = '" + Selecteditem + "'";

SQLiteDatabasedb=this.getWritableDatabase();
Cursorc= db.rawQuery(sqlQuery, null);

if (c.moveToFirst()) {
    do {
        temp_array.add(c.getString(c.getColumnIndex("name")) +
            "," + c.getString(c.getColumnIndex("code")) +
            "," + ""
        );

Another solution is to select only the columnn you need:

StringsqlQuery="SELECT name, code FROM data where company = '" + Selecteditem + "'";

SQLiteDatabasedb=this.getWritableDatabase();
Cursorc= db.rawQuery(sqlQuery, null);

if (c.moveToFirst()) {
    do {
        temp_array.add(c.getString(c.getColumnIndex("name")) +
            "," + c.getString(c.getColumnIndex("code"))
        );