protected void ddlcategory_SelectedIndexChanged(object sender, EventArgs e)
{
string category = ddlcategory.SelectedItem.Text;
if (category == "Web Technology")
{
MView.SetActiveView(viewWT);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewWT.DataSource = dt;
GviewWT.DataBind();
}
if (category == "Programming")
{
MView.SetActiveView(viewPro);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewPro.DataSource = dt;
GviewPro.DataBind();
}
if (category == "Database")
{
MView.SetActiveView(viewDB);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewDB.DataSource = dt;
GviewDB.DataBind();
}
if (category == "Operating System")
{
MView.SetActiveView(viewOS);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewOS.DataSource = dt;
GviewOS.DataBind();
}
if (category == "Computer Organisation And Architecture")
{
MView.SetActiveView(viewCOA);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewCOA.DataSource = dt;
GviewCOA.DataBind();
}
if (category == "Fundamental of Computers")
{
MView.SetActiveView(viewFOC);
DBAdmin db = new DBAdmin();
DataTable dt = db.ReadBulkData("select * from Tbl_Uploadmaterial where category='" + category + "'");
GviewFOC.DataSource = dt;
GviewFOC.DataBind();
}
}