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