protected void fillMasterPageSearch()
{
if (FilterProductname.SelectedIndex > -1)
{
string str = "select * from MasterPageMaster Where WebsiteSectionId='" + FilterProductname.SelectedValue + "' ";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
DDLmasterpageL.DataSource = ds;
DDLmasterpageL.DataTextField = "MasterPageName";
DDLmasterpageL.DataValueField = "MasterPageId";
DDLmasterpageL.DataBind();
DDLmasterpageL.Items.Insert(0, "-Select-");
DDLmasterpageL.Items[0].Value = "0";
}
else
{
DDLmasterpageL.DataSource = null;
DDLmasterpageL.DataTextField = "MasterPageName";
DDLmasterpageL.DataValueField = "MasterPageId";
DDLmasterpageL.DataBind();
DDLmasterpageL.Items.Insert(0, "-Select-");
DDLmasterpageL.Items[0].Value = "0";
}
}
protected void fillMasterPageSearch()
{
DDLmasterpageL.Items.Clear();
if (DDLWebsiteC.SelectedIndex > 0)
{
string strcln1 = " ";
DataTable dtcln = MyCommonfile.selectBZ(" SELECT dbo.MasterPageMaster.MasterPageId, dbo.MasterPageMaster.MasterPageName, dbo.MasterPageMaster.MasterPageDescription, dbo.MasterPageMaster.WebsiteSectionId FROM dbo.MasterPageMaster INNER JOIN dbo.WebsiteSection ON dbo.MasterPageMaster.WebsiteSectionId = dbo.WebsiteSection.WebsiteSectionId Where WebsiteSection.WebsiteMasterId='" + DDLWebsiteC.SelectedValue + "' ");
DDLmasterpageL.DataSource = dtcln;
DDLmasterpageL.DataValueField = "MasterPageId";
DDLmasterpageL.DataTextField = "MasterPageName";
DDLmasterpageL.DataBind();
}
DDLmasterpageL.Items.Insert(0, "-Select-");
}
