本文整理汇总了C#中DBConnection.BindDropdown方法的典型用法代码示例。如果您正苦于以下问题：C# DBConnection.BindDropdown方法的具体用法？C# DBConnection.BindDropdown怎么用？C# DBConnection.BindDropdown使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBConnection的用法示例。
在下文中一共展示了DBConnection.BindDropdown方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
GenderDDL.Items.Add("Male");
GenderDDL.Items.Add("Female");
//EmployeeType
EmployeeType empType = new EmployeeType();
DT = bindComboBox.BindDropdown(empType.SearchEmployeeTypes(), "Employee_Type_Name", "Employee_Type_Number");
EmployeeTypeDDL.DataSource = DT;
EmployeeTypeDDL.DataValueField = "Employee_Type_Name";
EmployeeTypeDDL.DataTextField = "Employee_Type_Number";
EmployeeTypeDDL.DataBind();
}示例2: VehicleDDL_SelectedIndexChanged
protected void VehicleDDL_SelectedIndexChanged(object sender, EventArgs e)
{
DBConnection db = new DBConnection();
ClientVehicle ClientV = new ClientVehicle();
DateDDL.DataTextField = "Project_StartDateTime";
DateDDL.DataValueField = "Project_Number";
DateDDL.DataSource = db.BindDropdown("SELECT Project.Project_Number, Project.Project_StartDateTime, Project.Project_TotalCost FROM Project WHERE Client_Vehicle_Number = " + VehicleDDL.SelectedItem.Value, "Project_StartDateTime", "Project_Number");
DateDDL.DataBind();
DateDDL.Items.Insert(0, "");
}示例3: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
}
}示例4: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (Application["username"] == null)
{
Response.Redirect("/Login");
}
if(!IsPostBack)
{
usernumber = Convert.ToInt32(Application["UserNumber"]);
VehicleDDL.Items.Clear();
DBConnection db = new DBConnection();
ClientVehicle cv = new ClientVehicle();
VehicleDDL.DataTextField = "Vehicle";
VehicleDDL.DataValueField = "Client_Vehicle_Number";
VehicleDDL.DataSource = db.BindDropdown(cv.SearchClientVehicles(usernumber), "GVehicle_Model", "Client_Vehicle_Number");
VehicleDDL.DataBind();
VehicleDDL.Items.Insert(0, "");
}
}示例5: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
Client c = new Client();
c.SearchClients("");
List<Cli> myLi = new List<Cli>();
foreach (Client inC in ClientBindingList.MyClientList)
{
userNumbersList.Add(inC.UserNumber);
Cli me = new Cli();
me.FirstName = inC.FirstName;
me.Surname = inC.Surname;
me.ContactNumber = inC.ContactNumber;
myLi.Add(me);
}
gvwStudents.DataSource = myLi;
gvwStudents.DataBind();
//City
DBConnection bindComboBox = new DBConnection();
City cities = new City();
DataTable DT = new DataTable();
DT = bindComboBox.BindDropdown(cities.SearchCities(), "City_Name", "City_Number");
CityDDL.DataSource = DT;
CityDDL.DataValueField = "City_Number";
CityDDL.DataTextField = "City_Name";
CityDDL.DataBind();
GenderDDL.Items.Add("Male");
GenderDDL.Items.Add("Female");
}