实现ListBox多选并显示数据的方法

<%@ Page Language="C#" AutoEventWireup="true" Debug="true"%>  
<%@import namespace="System.Data"%>  
<%@import namespace="System.Data.SqlClient"%>  
  
  
  
"server">  
"ckbEmployees" runat="server" RepeatLayout="table" RepeatDirection="vertical" RepeatColumns="3" CellPadding="9" CellSpacing="18" TextAlign="right" OnSelectedIndexChanged="subListChange" AutoPostBack="true" />  


  
"dgEmployee" runat="server" />  
  
  
  
"c#" 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.