1. Try yourself first, if you have proper connection string and stored procedure which returning multiple tables, you will get DataSet with multiple tables.
2. DataSet can have multiple DataTables, if your stored procedure returning multiple tables, then you can access each table by using your dataset Tables property. You can save DataTable to CSV file, just google for it, you will find many solutions and related code samples.
3. you can iterate all the Datatables in the dataset and call each datatable with export to CSV code which you find on step 2.
4. when you save csv file, give the name with date time stamp, check
Append TimeStamp to a File Name[
^]