//在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;

}