在session状态中保存数据库数据

//在session状态中保存数据库数据
DataView dvMovies;
dvMovies = (DataView)Session["Movies"];
if (dvMovies==null)
{
string constring = "Data Source=.;Initial Catalog=BalloonShop;Integrated Security=True";
SqlDataAdapter dad = new SqlDataAdapter("select * from Catagory", constring);
DataTable dtblMovies = new DataTable();
dad.Fill(dtblMovies);
dvMovies = new DataView(dtblMovies);
Session["Movies"] = dvMovies;
}

posted @ 2013-02-18 10:46  yellowshorts  阅读(204)  评论(0编辑  收藏  举报