DropDownList 内容选中后的实现方法:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace 数据库绑定
{
public partial class DDL的链接 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
getdata();
}
private void getdata()
{
string conn=ConfigurationManager.ConnectionStrings ["connstring"].ToString ();
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from Employees", con);
DataSet ds = new DataSet();
sda.Fill(ds);
ddlData.DataTextField = "FirstName";
ddlData.DataValueField = "EmployeeID";
ddlData.DataSource = ds;
ddlData.DataBind();
将选项钉死
//ListItem li = ddlData.Items.FindByText("Janet");
//if (li != null)
//{
// li.Selected = true;
//}
}
protected void ddlData_TextChanged(object sender, EventArgs e)
{
string selname = string.Empty;
foreach (ListItem itm in ddlData .Items )
{
if (itm.Selected)
{
selname += itm.Text + " " + itm.Value + ",";
}
}
if (!string.IsNullOrEmpty(selname))
{
selname = selname.Remove(selname.Length - 1);
}
Response.Write("你选定的是" + selname);
}
}
}
ListBox内容选中的时候显示方法:
public partial class Listbox的链接 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Getdata();
}
}
private void Getdata()
{
string conn=ConfigurationManager .ConnectionStrings ["connstring"].ToString ();
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from Employees",con );
DataTable dt = new DataTable();
sda.Fill(dt);
lbData.DataTextField = "Lastname";
lbData.DataValueField = "EmployeeID";
lbData.DataSource = dt;
lbData.DataBind();
con.Close();
}
protected void lbData_SelectedIndexChanged(object sender, EventArgs e)
{
string selname = string.Empty;
foreach (ListItem itm in lbData.Items)
{
if (itm.Selected)
{
selname += itm.Text + " " + itm.Value + ",";
}
}
if (!string.IsNullOrEmpty(selname))
{
selname = selname.Remove(selname.Length - 1);
}
Response.Write("你选定的是" + selname);
}