Android Coding Tips

To quote from the website of sqlite "SQLite is a software library that implements a self-contained , serverless , zero-configuration , transactional SQL database engine." It is small database which an android programmer can use conveniently in his/her program. Let us learn how to use sqlite database in steps. Opening database : openOrCreateDatabas e fuction can be used to open an existing db or create a new one if it does not exist. SQLiteDatabase mydb; mydb = mContext.openOrCreateDatabase("mysqdb", SQLiteDatabase.OPEN_READWRITE, null);  First parameter is name of database and second one is mode of opening the file. Third parameter if present will be cursorfactory which is used to allow sub classes of cursor to be returned from a query. You can even use openDatabase function. On success the db is returned. The function throws SqliteException if there is error. Next let us try to create a table with 3 fields - id, name and salary. We need to

AlertDialog is a versatile dialog. It can be used even for displaying a list where multiple values can be checked. First you create a alertdialog. AlertDialog.Builder  d = new AlertDialog.Builder(yourcontext); Next you create the array which holds the items to be displayed   String elements [] = {"Burger","Pizza","Cake","Coke","Fruits"}; Next you add multichoiceitems to the dialog d.setMultiChoiceItems(elements, null , new OnMultiChoiceClickListener() {  @Override  public void onClick(DialogInterface dialog, int which, boolean isChecked) {        if(isChecked){           String str = elements[which];           Toast.makeText(youractivity.this,                     "you have  selected"+str,                      Toast.LENGTH_LONG).show();         }    }  }); d.setPositiveButton("Save", new OnClickListener() {    @Override    public void onClick(DialogInterface dialog, int which) { yourOnClic