How to add datatable object to dataset and returnm dataset

See more:

C#

Hi,

I want to add datatable object to dataset. I can add at a time single object to dataset but now I want to select data from multiple tables in datatables. Finally, I want to add all datatables to dataset and return dataset.

I am unable to append datatable to dataset.

Following is the code I have where tablename is the list of table names:

public DataSet MultipleSelectRecord(string databasename,List<string>tablename)
       {
           try
           {
              DataSet AppendDs =new DataSet ();
               for (int i = 0; i < tablename.Count; i++)
               {
                   string query = " USE " + databasename + " SELECT * FROM " + tablename[i] + " ";
                   da = new SqlDataAdapter(query , con);
                   DataTable dtobj = new DataTable();
                   da.Fill(dtobj);
                  
                   AppendDs.Tables.Add(dtobj);//it replace previous dataset record this is problem
               }
               return AppendDs;
           }
           catch (Exception ex)
           {
               throw new Exception(ex.Message);
           }

       }</string>

Thank you.

Edit: Added pre tag.