Data Retival

SqlConnection con = new SqlConnection(conString);

string sql = "Select * from HumanResources.Employee";

SqlCommand cmd = new SqlCommand(sql, con);
ds = new DataSet();
SqlDataAdapter adpt = new SqlDataAdapter(cmd);

adpt.Fill(ds);