本文向大家介绍C# ListBox多选,可能好多人还不了解C# ListBox多选,没有关系,看完本文你肯定有不少收获,希望本文能教会你更多东西。
C# ListBox多选并显示数据似乎有些难,但是大家看了笔者实现此内容的代码已经就不会觉得很难了。
<%@ Page Language="C#" AutoEventWireup="true" Debug="true"%>
<%@import namespace="System.Data"%>
<%@import namespace="System.Data.SqlClient"%>
"ckbEmployees" runat="server" RepeatLayout="table" RepeatDirection="vertical" RepeatColumns="3" CellPadding="9" CellSpacing="18" TextAlign="right" OnSelectedIndexChanged="subListChange" AutoPostBack="true" />
"dgEmployee" runat="server" />
private void Page_load(object sender,System.EventArgs e)
{
if(!IsPostBack)
{
string strConnection ="server=.;uid=sa;pwd=sunix!;database=northwind";
string strSQLforCheckBoxes = "select LastName ,EmployeeID from employees order by lastname";
SqlConnection objConnection = new SqlConnection(strConnection);
SqlCommand objCommand = new SqlCommand(strSQLforCheckBoxes,objConnection);
objConnection.Open();
ckbEmployees.DataSource = objCommand.ExecuteReader();
ckbEmployees.DataTextField = "LastName";
ckbEmployees.DataValueField = "EmployeeID";
ckbEmployees.DataBind();
objConnection.Close();
}
}
private void subListChange(object s,System.EventArgs e)
{
Response.Write("subListchange triggered
");
string strWhereClause="";
foreach (ListItem liThisOne in ckbEmployees.Items)
{
if(liThisOne.Selected)
{
strWhereClause += "EmployeeID = " + liThisOne.Value + " OR ";
}
}
Response.Write("strWhereClause=
"+strWhereClause+"
");
if(strWhereClause.Length>0)
{
dgEmployee.Visible = true;
string str = strWhereClause.Substring(0,strWhereClause.Length - 3);
strWhereClause = " where " + str;
string strConnection = "server=.;uid=sa;pwd=sunix!;database=northwind";
string strSQLforGrid = "select TitleOfCourtesy,firstName,lastName,country,region,city,notes from employees " + strWhereClause;
//Response.Write(strSQLforGrid); sql语句之间的空格,否则出错
SqlConnection objConnection = new SqlConnection(strConnection);
SqlCommand objCommand = new SqlCommand(strSQLforGrid,objConnection);
Response.Write("strSQLforGrid=
"+strSQLforGrid+"
");
objConnection.Open();
dgEmployee.DataSource = objCommand.ExecuteReader();
dgEmployee.DataBind();
objConnection.Close();
}
else
{
dgEmployee.Visible = false;
}
}
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44.
- 45.
- 46.
- 47.
- 48.
- 49.
- 50.
- 51.
- 52.
- 53.
- 54.
- 55.
- 56.
- 57.
- 58.
- 59.
- 60.
- 61.
- 62.
- 63.
- 64.
- 65.
- 66.
- 67.
- 68.
- 69.
- 70.
- 71.
怎样,笔者分享的C# ListBox多选并显示数据的代码希望大家有用!
【编辑推荐】