Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
V

Varma Lanke

@Varma Lanke
About
Posts
1
Topics
1
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Populate Spinner from Sqlite and display the associated record of selected or populated item
    V Varma Lanke

    My Database Helper Code is Here

    public class DataHelper extends SQLiteOpenHelper {
    public static final String DB_NAME="myDb";
    public static final String Table_Pro="student";

    public static final String Create_Pro="Create table if not exists "+Table_Pro+"(id integer primary key autoincrement,pname not null unique,age int,qual text)";

    public static final String Delete\_Pro="Drop table if exists "+Table\_Pro;
    
    
    
    public DataHelper(Context context) {
        super(context, DB\_NAME, null, 1);
    
    }
    
    @Override
    public void onCreate(SQLiteDatabase db) {
      db.execSQL(Create\_Pro);
    
    }
    
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL(Delete\_Pro);
       // db.execSQL("DROP TABLE IF EXISTS "+Table\_Pro);
        onCreate(db);
    
    }
    public void insertProvince(String pname,int age,String qual)
    {
        SQLiteDatabase db=this.getWritableDatabase();
        db.beginTransaction();
        ContentValues values;
        try
        {
            values=new ContentValues();
            values.put("pname",pname);
            values.put("age",age);
            values.put("qual",qual);
            db.insert(Table\_Pro, null, values);
            db.setTransactionSuccessful();
    
        }catch (Exception e)
        {
            e.printStackTrace();
        }
        finally {
            db.endTransaction();
            db.close();
        }
    
    
    }
    public ArrayList<String> getAllProvinces()
    {
        ArrayList<String> list=new ArrayList<String>();
        SQLiteDatabase db=this.getReadableDatabase();
        db.beginTransaction();
    
        try
        {
            String selectQuery = " SELECT \* FROM "+ Table\_Pro;
    
                    Cursor cursor=db.rawQuery(selectQuery,null);
            if(cursor.getCount()>0)
            {
                while (cursor.moveToNext())
                {
                    String pname=cursor.getString(cursor.getColumnIndex("pname"));
                    list.add(pname);
                }
            }
            db.setTransactionSuccessful();
        }catch (Exception e)
        {
            e.printStackTrace();
        }
        finally {
            db.endTransaction();
            db.close();
        }
        return list;
    
    }
    

    public Cursor getAllDa

    Android database sqlite
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups