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(); }