public void GetCompany() { DataSet ds; CustomProfile profile = CustomProfile.GetProfile(); iProductMasterClient productClient = new iProductMasterClient(); iUCCommonFilterClient objService = new iUCCommonFilterClient(); try { ds = productClient.GetCompanyname(profile.DBConnection._constr); List <mCompany> CompanyLst = new List <mCompany>(); long UID = profile.Personal.UserID; string UserType = profile.Personal.UserType.ToString(); if (UserType == "Admin") { CompanyLst = objService.GetUserCompanyNameNEW(UID, profile.DBConnection._constr).ToList(); } else { CompanyLst = objService.GetCompanyName(profile.DBConnection._constr).ToList(); } //ddlcompany.DataSource = ds; ddlcompany.DataSource = CompanyLst; ddlcompany.DataTextField = "Name"; ddlcompany.DataValueField = "ID"; ddlcompany.DataBind(); ListItem lst = new ListItem { Text = "-Select-", Value = "0" }; ddlcompany.Items.Insert(0, lst); } catch { } finally { productClient.Close(); } }