I need to make 2 separate database calls using 2 stored procedures. Each call will return a different result set. Currently I just make 1 call and bind the results to a datatable. I'm rather new to asp.net so I dont know the best way of going about this. I googled it and saw that you can fill a dataset with 2 sets of results but I could not find any good examples. I will attach the code im using to fill my datatable right now. If you could show me how I would convert that code to make 2 stored procedure calls to fill my dataset that would be great.
//Page is rendered for the First Time.
SqlCommand myCommand = null;
//Open a Connection to SQL Server.
SqlConnection myConnection = new SqlConnection(ConnectionString);
//Set up my Stored Procedure.
myCommand = new SqlCommand("Media_GetMedia", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
//Execute the Stored Procedure and Fill the datatable
DataTable myDataTable = new DataTable();
SqlDataAdapter myDataAdapter = new SqlDataAdapter(myCommand);
//Bind the table to my FormView
FormView1.DataSource = myDataTable;
//Close Database Connection
//Close my connection.