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";
string sql = "select * from dvds";
string sql2 = "select * from category";
string sql3 = "select * from casting";
string sql4 = "select * from type";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
SqlDataAdapter adapter1 = new SqlDataAdapter(sql2, conn);
SqlDataAdapter adapter2 = new SqlDataAdapter(sql3, conn);
SqlDataAdapter adapter3 = new SqlDataAdapter(sql4, conn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
SqlCommandBuilder builder1 = new SqlCommandBuilder(adapter1);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2);
SqlCommandBuilder builder3 = new SqlCommandBuilder(adapter3);
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
DataSet ds3 = new DataSet();
adapter.Fill(ds, "dvd");
adapter1.Fill(ds1, "category");
adapter2.Fill(ds2, "casting");
adapter3.Fill(ds3, "type");
ds.Tables["dvd"].PrimaryKey = new DataColumn[] { ds.Tables["dvd"].Columns["dvdid"] };
ds1.Tables["category"].PrimaryKey = new DataColumn[] { ds1.Tables["category"].Columns["id"] };
ds2.Tables["casting"].PrimaryKey = new DataColumn[] { ds2.Tables["casting"].Columns["id"] };
ds3.Tables["type"].PrimaryKey = new DataColumn[] { ds3.Tables["type"].Columns["id"] };
Cache["DATASET"] = ds;
Cache["DATASET1"] = ds1;
Cache["DATASET2"] = ds2;
Cache["DATASET3"] = ds3;
Cache["ADAPTER"] = adapter;
Cache["ADAPTER1"] = adapter1;
Cache["ADAPTER2"] = adapter2;
Cache["ADAPTER3"] = adapter3;
dvd.DataSource = ds.Tables["dvd"];
category.DataSource = ds1.Tables["category"];
casting.DataSource = ds2.Tables["casting"];
type.DataSource = ds3.Tables["type"];
dvd.DataBind();
category.DataBind();
casting.DataBind();
type.DataBind();
DropDownListcat.DataSource = ds1.Tables["category"];
DropDownListcat.DataTextField = "categorymv";
DropDownListcat.DataValueField = "id";
DropDownListcat.DataBind();
DropDownListcast.DataSource = ds2.Tables["casting"];
DropDownListcast.DataTextField = "actor";
DropDownListcast.DataValueField = "id";
DropDownListcast.DataBind();
DropDownListtype.DataSource = ds3.Tables["type"];
DropDownListtype.DataTextField = "typemv";
DropDownListtype.DataValueField = "id";
DropDownListtype.DataBind();
}
private void LoadFrmCache()
{
DataSet ds = (DataSet)Cache["DATASET"];
DataSet ds1 = (DataSet)Cache["DATASET1"];
DataSet ds2 = (DataSet)Cache["DATASET2"];
DataSet ds3 = (DataSet)Cache["DATASET3"];
dvd.DataSource = ds.Tables["dvd"];
category.DataSource = ds1.Tables["category"];
casting.DataSource = ds2.Tables["casting"];
type.DataSource = ds3.Tables["type"];
dvd.DataBind();
category.DataBind();
casting.DataBind();
type.DataBind();
DropDownListcat.DataSource = ds1.Tables["category"];
DropDownListcat.DataTextField = "categorymv";
DropDownListcat.DataValueField = "id";
DropDownListcat.DataBind();
DropDownListcast.DataSource = ds2.Tables["casting"];
DropDownListcast.DataTextField = "actor";
DropDownListcast.DataValueField = "id";
DropDownListcast.DataBind();
DropDownListtype.DataSource = ds3.Tables["type"];
DropDownListtype.DataTextField = "typemv";
DropDownListtype.DataValueField = "id";
DropDownListtype.DataBind();
}