//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();
}
}
