void Loaddata()
{
string connStr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string sql = "SELECT dvdid,title,description,actor,type,category,date FROM dvds dvd,casting cas,type tp, category ct where dvd.castingId=cas.id and dvd.typeid=tp.id and dvd.categoryid=ct.id";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds, "dvd");
ds.Tables["dvd"].PrimaryKey = new DataColumn[] { ds.Tables["dvd"].Columns["dvdid"] };
Cache["DATASET"] = ds;
Cache["ADAPTER"] = adapter;
GridViewhome.DataSource = ds.Tables["dvd"];
GridViewhome.DataBind();
}
private void LoadFrmCache()
{
DataSet ds = (DataSet)Cache["DATASET"];
GridViewhome.DataSource = ds.Tables["dvd"];
GridViewhome.DataBind();
}
