hi,
if you use Dataset, please use code like this
DataSet ds=new DataSet();
SqlDataAdapter dataadpt=new SqlDataAdapter(cmd);
dataadpt.Fill(ds);
Gridview1.DataSource=ds;
Gridview1.Databind();
if you use DataTable,
same as dataset.but small difference is
Gridview1.DataSource=ds.Tables[0];
Gridview1.Databind();
because Collection of Datatable is called as DataSet.
Hope this is useful to you,
Thanks and regards
Angappan.S