Member Avatar for john_beginner

Hi all,

I am beginner in android and,

My question is i want to know where my SQLite database physically reside in my system when i create it as

SQLiteDatabase db = openOrCreateDatabase("MyDB1", Context.MODE_PRIVATE, null);

db.execSQL("CREATE TABLE IF NOT EXISTS MyTable(LName TEXT,FName TEXT,No INTEGER PRIMARY KEY);");

 db.execSQL("INSERT INTO MyTable(No) VALUES(123);");

 db.close();

and also want to know more about SQLite with android please let me know any site name which provide me some good guide line for database connection with SQLite with Android

thanx in advance :)

  • 3 Contributors
  • 6 Replies
  • 89 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by john_beginner
Member Avatar for sharathg.satya

hello john
with the basic knowledge i am having the database created using sqlite is a virtual one
it cannot be viewed externally

Member Avatar for john_beginner

thank you but can you suggest me any good tutorial for SQLite on internet ?

Member Avatar for sharathg.satya

i dont know specific sites that helps you but i think u can look the android's sitedeveloper.android.com/resources/tutorials/
i am not confident on how much this may help u
but u can view it
and jst try to google by asking your doubts in google
this is the only way to get some idea on the topic u wish

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.