Is it possible to load data into the datatables using the same stored procedure or do I need to load each datatable separately?

Rex,

Yes, you can use the same SP to load the data. Just use DataAdapter.Fill(MyDataSet) as you would for loading data into any dataset. Just be sure that the SqlCommand is the name of your SP. Something like this:

SqlCommand sc = new SqlCommand("MySP", this.MyConnection);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@MyPK", MyPKValue);
SqlDataAdapter da = new SqlDataAdapter(sc);

da.Fill(MyDataSet);

~~Bonnie