Dataset is the collection of the DataTable as figure:

The following example shows DataAdapter in c#. 

//these lines are for creating a new connection by passing server name,uid,password and name of the database as here mind.
  
SqlConnection con = newSqlConnection("server=abc-pc1\\sqlexpress; uid=sa; password=sa; database=mind");
//open connection       
con.Open();
//create a data adapter and invoking the command.
SqlDataAdapter ad = newSqlDataAdapter("select * from Employee", con);
//creating dataset object
DataSet ds=new DataSet();
ad.fill(ds)//use dataadapter to fill data table
 //close the connection
con.Open();