Query = "select * from dbo.Movie";
SqlDataAdapter da = new SqlDataAdapter(Query, connection);
da.Fill(ds, "dbo.Movie");
var tbl = from p in ds.Tables["dbo.Movie"].AsEnumerable()
where p.Field<int>("ID") == Convert.ToInt32(TextBox1.Text)
select new p;
GridView1.Visible = true;
GridView1.DataSource = tbl.Tabels[0].DefaultView;
GridView1.DataBind();
or
DataTable table = (DataTable)Session["Save"];
var query = from c in table.AsEnumerable()
select new { c.Week,c.Person,c.Guess,c.Actual};
GridView2.DataSource = query;
GridView2.DataBind();