How We get data from SQLite database in Android?

Question

Hi friends we want know that we get data from SQLite database in Android?

Chintan Rathod · Answer

Hi Abhishek Here is the code for getting information from SQLite database. Code: import android.app.Activity; import android.database.Cursor; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.util.Log; import android.widget.Toast; public class DataBaseDemoActivity extends Activity { //declaring object of SQLiteDatabase SQLiteDatabase db; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); try{ //opening database ( here database is StudentDB ) db=openOrCreateDatabase(StudentDBSQLiteDatabase.CREATE_IF_NECESSARYnull); }catch(SQLException e) { Log.d(ErrorError while Opening Database); e.printStackTrace(); } //defining cursor and select all rows from table named student Cursor c=db.rawQuery(SELECT * FROM studentnull); try { //put cursor on the first position c.moveToFirst(); //fetching all records from cursor until reaching last record while(!c.isAfterLast()) { /* * Display record on the screen * Note : here in the cursor there are two columns. * So be careful while fetching record. * If no column is there it will give you exception */ Toast.makeText(DataBaseDemoActivity.thisc.getString(0)+  +c.getString(1)1000).show(); //moving cursor to next record c.moveToNext(); } //closing cursor c.close(); }catch(Exception e) { Log.d(Errorerror in cursor); e.printStackTrace(); } } @Override protected void onStop() { //closing database. its recommended. db.close(); super.onStop(); } } and you can also see my article based on handling SQLite => http://www.c-sharpcorner.com/UploadFile/88b6e5/sqlitedatabase-connectivity/ Thanks & Regards ---------------- Chintan Rathod

Ehtesham Mehmood · Answer

Hy Abishek here is the complete article of your problem. http://www.go2code.com/sqlite-with-gridview-in-android-2/

Mubeezi MICAH · Answer

Thank you so much Chintan. I have been trying to make this work for the past 3 days in vain.

Satyapriya Nayak · Answer

Hi Abhishek Please refer the below links http://www.hdelossantos.com/2010/01/07/using-a-sqlite-database-in-android/ http://www.codeproject.com/Articles/119293/Using-SQLite-Database-with-Android Thanks