protected void fillfilterproduct() { DataTable dtcln = selectBZ("SELECT distinct ProductMaster.ProductId, VersionInfoMaster.VersionInfoId,ProductMaster.ProductName + ' : ' + VersionInfoMaster.VersionInfoName as productversion FROM ProductMaster inner join VersionInfoMaster on ProductMaster.ProductId=VersionInfoMaster.ProductId inner join ProductDetail on ProductDetail.VersionNo=VersionInfoMaster.VersionInfoName where ClientMasterId=" + Session["ClientId"].ToString() + " and ProductDetail.Active ='True' order by productversion"); FilterProductname.DataSource = dtcln; FilterProductname.DataValueField = "VersionInfoId"; FilterProductname.DataTextField = "productversion"; FilterProductname.DataBind(); FilterProductname.Items.Insert(0, "All"); FilterProductname.Items[0].Value = "0"; }
protected void FillProduct() { DataTable dtcln = MyCommonfile.selectBZ(" SELECT distinct ProductMaster.ProductId,ProductMaster.ProductName,ProductMaster.ProductName +':'+ VersionInfoMaster.VersionInfoName as aa,VersionInfoMaster.VersionInfoId FROM ProductMaster inner join ProductDetail on ProductDetail.ProductId=ProductMaster.ProductId inner join VersionInfoMaster on VersionInfoMaster.ProductId=ProductMaster.ProductId where ClientMasterId=" + Session["ClientId"].ToString() + " and ProductDetail.Active='1' and VersionInfoMaster.Active='1' order by ProductName"); FilterProductname.DataSource = dtcln; FilterProductname.DataValueField = "VersionInfoId"; FilterProductname.DataTextField = "ProductName"; FilterProductname.DataBind(); FilterProductname.Items.Insert(0, "All"); FilterProductname.Items[0].Value = "0"; }
protected void FilterProduct() { string strcln = " SELECT distinct WebsiteMaster.ID as WebsiteMaster_ID,VersionInfoMaster.VersionInfoId,MasterPageMaster.MasterPageId,VersionInfoMaster.VersionInfoId,MasterPageMaster.MasterPageName,WebsiteSection.WebsiteSectionId, ProductMaster.ProductName + ':'+ VersionInfoMaster.VersionInfoName + ' : '+ WebsiteMaster.WebsiteName + ':' + WebsiteSection.SectionName + ':' + MasterPageMaster.MasterPageName as MasterPage_Name ,MasterPageMaster.MasterPageId FROM ProductMaster inner join VersionInfoMaster on ProductMaster.ProductId=VersionInfoMaster.ProductId inner join ProductDetail on ProductDetail.ProductId=ProductMaster.ProductId inner join WebsiteMaster on WebsiteMaster.VersionInfoId=VersionInfoMaster.VersionInfoId inner join WebsiteSection on WebsiteSection.WebsiteMasterId=WebsiteMaster.ID inner join MasterPageMaster on MasterPageMaster.WebsiteSectionId=WebsiteSection.WebsiteSectionId where ProductMaster.ClientMasterId='" + Session["ClientId"] + "' and VersionInfoMaster.Active ='True' and ProductDetail.Active='1' order by MasterPage_Name"; SqlCommand cmdcln = new SqlCommand(strcln, con); DataTable dtcln = new DataTable(); SqlDataAdapter adpcln = new SqlDataAdapter(cmdcln); adpcln.Fill(dtcln); FilterProductname.DataSource = dtcln; FilterProductname.DataValueField = "MasterPageId"; FilterProductname.DataTextField = "MasterPage_Name"; FilterProductname.DataBind(); //FilterProductname.Items.Insert(0, "All"); //FilterProductname.Items[0].Value = "0"; }