dataset is front end memory by using dataset we can get data from backend
and fill into DataAdapter.
Datatable is also same purpose like dataset but it use ful in runtime very much
datagridview useful to get data in table format.
See the following code
sqldataadapter da= new SqlDataAdater("select * from Employee", con);
DataSet ds = new DataSet();
da.Fill(ds);
datagridview1.DataSource = ds.table[0];
sqldataadapter da = new SqlDataAdater("select * from Employee", con);
DataTable dt = new DataTable();
da.Fill(dt);
datagridview1.DataSource = dt;