I have two activities, Activity A and Activity B. Activity B is creating a database, inserting data to it, editing data and then closing the database. Activity A is an empty screen and it calls activity B. Activity B finishes its database work and goes back to activity A. Now I want my activity A to access the database created and modified by Activity B. It might be a very simple solution, please excuse me if it is a silly question. Any clue will is highly appreciated.
Thanks, Shaista
To access the data in Activity A, use the onActivityResult() in Activity A in the following way:
@Override protected void onActivityResult(int requestCode, int resultCode, ntent intent) { super.onActivityResult(requestCode, resultCode, intent); if (requestCode == PICK_CONTACT_REQUEST && resultCode == 10) { pos = intent.getIntExtra("doc_id", 1); mDbHelper.open(); /* Write the database accessing code and whatever you want to do on returning back from Activity B here. */ mDbHelper.close(); } } And also remember that you can use this method with the intent method with calling startActivityForResult() with intent That's it, what you have to do
If there is any confusion then you can ask
EDIT: This code will help in fetching the data
public class FirstActivity extends Activity { AnyDBAdapter mDbHelper = new AnyDBAdapter(this); @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); mDbHelper.open(); Cursor foemiCursor = mDbHelper.fetchAll();/*fetchAll() is which you need to create in AnyDBAdapter class showing query for fetching the database */ startManagingCursor(foemiCursor); /*Now the query will get executed and you need to access just vales from it, here you write code for it*/ foemiCursor.close(); mDbHelper.close(); } 
You should make a DBAdapter class to handle all of your database interaction. The database is SQL Lite and is for the whole application. Just access it in B as you did in A.
use content provider...But directly your activity cannot interact with content provider activity interact with content Resolver and than resolver interact with content provider so now you can access data of other activity.
You should check this link, http://kagii.squarespace.com/journal/2010/9/10/android-sqlite-locking.html. It contains some good information on how to use databases on android.
