can i use one dataset to store two tables

See more:

.NET3.5

C#

.NET

ADO.NET

how do i use one dataset to store two tables and
get data from each table separately ?

here is my code: i jus want to use the dataset only once, and not code it like how i have did, is it possible....

SqlConnection con = new SqlConnection(CS);
          con.Open();
          SqlDataAdapter da = new SqlDataAdapter("sp_GetEmpDesignation", con);
         SqlCommandBuilder cmdbuild = new SqlCommandBuilder(da);
          DataSet ds = new DataSet();
         da.Fill(ds,"EmpDesignation");
          //BindingSource bgs = new BindingSource(ds, "EmpDesignation");
          //// bgs.DataSource = ds;

         BindingSource bs = new BindingSource(ds, "EmpDesignation");
         //dataGridView1.DataSource = bs;
         comboBoxDesg.DataSource = bs;
         comboBoxDesg.DisplayMember = "designation";
         comboBoxDesg.ValueMember = "desgid";

         SqlDataAdapter da1 = new SqlDataAdapter("GetDepartment", con);
         SqlCommandBuilder cmdbuild1 = new SqlCommandBuilder(da1);
         DataSet ds1 = new DataSet();
         da1.Fill(ds1,"Department");
         BindingSource bs1 = new BindingSource(ds1, "Department");
         comboBoxDept.DataSource = bs1;
         comboBoxDept.DisplayMember = "department";

         //SqlDataAdapter dac = new SqlDataAdapter("sp_GetEmpDesignation", con);
         con.Close();