//Company OwnerShip details dropdown List Population protected void PopulateDropDownList() { String strLoggedUsers = String.Empty; DataTable subjects = new DataTable(); DataTable subjects2 = new DataTable(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; SqlDataAdapter adapter = new SqlDataAdapter("select FirstName +' ' + LastName as FullName, LoginID from dbo.Logins WHERE Active = 'Y' and LoginID =38 ", conn); adapter.Fill(subjects); RepNameDropDownList.DataSource = subjects; RepNameDropDownList.DataTextField = "FullName"; RepNameDropDownList.DataValueField = "LoginID"; RepNameDropDownList.DataBind(); SqlDataAdapter adaptertt = new SqlDataAdapter("select FirstName +' ' + LastName as FullName, LoginID from dbo.Logins WHERE Active = 'Y' and LoginID NOT IN ( 25, 19,18,23,26,8,21,22)", conn); adaptertt.Fill(subjects2); NumberAccountDropDownList.DataSource = subjects2; NumberAccountDropDownList.DataTextField = "FullName"; NumberAccountDropDownList.DataValueField = "LoginID"; NumberAccountDropDownList.DataBind(); } //Get the Current Account OwnerShip }
protected void PopulateDropDownList() { String strLoggedUsers = String.Empty; DataTable subjects = new DataTable(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString; SqlDataAdapter adapter = new SqlDataAdapter("select FirstName +' ' + LastName as FullName, LoginID from dbo.Logins WHERE Active = 'Y' and LoginID NOT IN (25,23,26,8,21,22,24,33)", conn); adapter.Fill(subjects); RepNameDropDownList.AppendDataBoundItems = true; RepNameDropDownList.DataSource = subjects; RepNameDropDownList.DataTextField = "FullName"; RepNameDropDownList.DataValueField = "LoginID"; RepNameDropDownList.DataBind(); } }