Multiple Datatable Select In C# And Sql?

Hello.

I have 2 diffrent tables in the database, is it possible to select both of those back to c# on the same time?

I DONT want to combine the tables, just select them into 2 diffrent datatables in one select statement?

At the moment, i have something like:

function XX
OpenDBCon();
mCom.Parameters.Clear();
mCom.CommandText = "Stuff_GetMovieCategories";
myAdap = new SqlDataAdapter();
myTable = new DataTable();
myAdap.SelectCommand = mCom;
myAdap.Fill(myTable);
CloseDBCon();
return myTable;

Can i ask the database to perhaos retrieve Stuff_GetMovieCategories and on the same time retrieve Stuff_MostViewedMovies?

So the SP does 2 select statements and returns them, i get in the function above 2 datatables with the information, one datatable with Categories and one table with MostViewedMovies.

Is this possible?