这里使用到了两张表:部门表和员工表 SQL脚本如下: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Emp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Emp] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Department]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Department] GO
CREATE TABLE [dbo].[Department] ( [DeptID] [int] IDENTITY (1, 1) NOT NULL , [Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO
前台代码:
<%@ Page language="c#" Codebehind="ListBoxToListBox.aspx.cs" AutoEventWireup="false" Inherits="NetTest.ListBoxTest.ListBoxToListBox" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>ListBoxToListBox</title> <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" Content="C#"> <meta name="vs_defaultClientScript" content="JavaScript"> <link href="../CSS/BasicLayout.css" rel="stylesheet" type="text/css"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <style type="text/css"> .fsize { FONT-SIZE: 10pt } </style> </HEAD> <body MS_POSITIONING="GridLayout"> <script language="javascript"> function BindListEmp() { var DeptID=document.getElementById("ddlDept").value; var obj=AjaxMethod.GetEmpByDeptID(DeptID); if(obj.value!=null) { document.all("listEmployees").length=0; var ds=obj.value;
if(ds != null && typeof(ds) == "object" && ds.Tables != null) { for(var i=0; i<ds.Tables[0].Rows.length; i++) { var name=ds.Tables[0].Rows[i].EmpName; var id=ds.Tables[0].Rows[i].EmpID; //alert(name); //alert(id); document.all("listEmployees").options.add(new Option(name,id)); } } else { } } else { } } </script> <script language="javascript"> function GetData() { listNewEmp = eval("document.FrmListBox.listNewEmp"); document.getElementById("txtEmpID").value=""; for(i=0;i<listNewEmp.length;i++) { document.FrmListBox.txtEmpID.value+=listNewEmp.options[i].value+","; } } function AddItem(ControlName) { Control = null; Control=eval("document.FrmListBox.listNewEmp"); var x=0; var i=0; var y=0; listEmployees=eval("document.FrmListBox.listEmployees"); listNewEmp=eval("document.FrmListBox.listNewEmp"); var j=listEmployees.length;
using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using Ajax; namespace NetTest.ListBoxTest { /// <summary> /// ListBoxToListBox 的摘要说明。 /// </summary> public class ListBoxToListBox : System.Web.UI.Page { protected System.Web.UI.WebControls.DropDownList ddlDept; protected System.Web.UI.WebControls.Button btnSubmit; protected System.Web.UI.WebControls.ListBox listEmployees; protected System.Web.UI.WebControls.ListBox listNewEmp; protected System.Web.UI.WebControls.TextBox txtEmpID; private string strConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();