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