Notes

internal class Dataset
{
SqlConnection conn;
public Dataset()
{
conn = new SqlConnection("Data Source = (localdb)MSSQLLocalDB; Initial Catalog = University; Integrated Security = SSPI");

}
class program
{
static void Main()
{
Dataset obj = new Dataset();
try
{
DataTable Customer = new DataTable("Customers");
// Adding Data Columns to the Customer Data Table
DataColumn CustomerId = new DataColumn("ID", typeof(Int32));
Customer.Columns.Add(CustomerId);
DataColumn CustomerName = new DataColumn("Name", typeof(string));
Customer.Columns.Add(CustomerName);
DataColumn CustomerMobile = new DataColumn("Mobile", typeof(string));
Customer.Columns.Add(CustomerMobile);
//Adding Data Rows into Customer Data Table
Customer.Rows.Add(101, "Anurag", "2233445566");
Customer.Rows.Add(102, "Manoj", "1234567790");
Customer.Rows.Add(103, "Arun", "1234567890");
Customer.Rows.Add(104, "Mayank", "1234127890");



SqlDataAdapter adap = new SqlDataAdapter("select * from tblEMployee", obj.conn);
SqlDataAdapter adap2 = new SqlDataAdapter("select * from tblDepartment", obj.conn);


//DataTable dt1 = new DataTable("EmployeeDetails");
DataSet ds = new DataSet();
adap.Fill(ds, "EmployeeDetails"); //filling the dataset with a table with the query above
adap2.Fill(ds, "Departments");
ds.Tables.Add(Customer); //adding customer table in dataset so now we have two tables in the dataset



foreach (DataRow row in ds.Tables["EmployeeDetails"].Rows)
{
Console.WriteLine("{0} {1} {2} {3} {4}", row[0], row[1], row[2], row[3], row[4]);
}

Console.WriteLine("-----------------------------------------------");

foreach (DataRow row in ds.Tables["Departments"].Rows)
{
Console.WriteLine("{0} {1} {2} {3}", row[0], row[1], row[2], row[3]);
}



}
catch (Exception e)
{
Console.WriteLine(e.Message);
}