CascadingDropDown通常叫作级联下拉菜单,本文将通过读取Northwind数据库中的Emplyee、Order、OrderDatail信息作为示例,来展示一下它的使用。
主要内容
1.CascadingDropDown控件介绍
2.从数据库读取数据并填充CascadingDropDown
一.CascadingDropDown控件介绍
CascadingDropDown通常叫作级联下拉菜单,本文将通过读取Northwind数据库中的Emplyee、Order、OrderDatail信息作为示例,来展示一下它的使用。示例代码如下:
<
atlasToolkit:CascadingDropDown
ID
="CDD1"
runat
="server"
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
atlasToolkit:CascadingDropDownProperties
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
TargetControlID
="DropDownList2"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
Category
="Model"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
PromptText
="Please select a model"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
LoadingText
="[Loading models
]"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
ServicePath
="CarsService.asmx"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
ServiceMethod
="GetDropDownContents"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
ParentControlID
="DropDownList1"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SelectedValue
="SomeValue"
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</
atlasToolkit:CascadingDropDownProperties
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</
atlasToolkit:CascadingDropDown
>
对于CascadingDropDown需要为它添加CascadingDropDownProperties,有多少个下拉列表,就添加几个CascadingDropDownProperties,主要属性如下:
属性 | 说明 |
TargetControlID | 指定要扩展的DropDownList的ID |
Category | DropDownList表示的类别名称,在WebMethod中会用到 |
PromptText | 没有选择时显示的文字 |
LoadingText | 加载数据时显示的文字 |
ServicePath | 获取数据的Web Service,为每个DropDownList都要指定 |
ServiceMethod | 获取数据的Web Method |
ParentControlID | 要扩展的DropDownList的父控件ID |
SelectedValue | 默认的选择项的值 |
二.从数据库读取数据并填充CascadingDropDown
下面用读取Northwind数据库中的Emplyee、Order、OrderDatail信息,看一个完整的示例。在新建一个Web Site后,先在页面的头部加上:
<%
@ Register Assembly="AtlasControlToolkit"
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
Namespace="AtlasControlToolkit"
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
TagPrefix="atlasToolkit"
%>
加入三个DropDownList,分别用来显示Emplyee,Order,OrderDatail:
<
div
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
h3
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
Employee:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
asp:DropDownList
ID
="ddlEmployees"
runat
="server"
/><
br
/><
br
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
Order:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
asp:DropDownList
ID
="ddlOrders"
runat
="server"
/><
br
/><
br
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
Detail:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
asp:DropDownList
ID
="ddlOrderDetails"
runat
="server"
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</
h3
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</
div
>
下面我们添加一个Northwind.asmx的Web Service,编写相关的Web Method:
[WebMethod]
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
public
CascadingDropDownNameValue[] GetEmployees(
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
string
knownCategoryValues,
string
category)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection connection = new
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection(connectionString);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlCommand command = new SqlCommand("SELECT * FROM Employees");
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection = connection;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
connection.Open();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlDataAdapter adapter = new SqlDataAdapter(command);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataSet dataSet = new DataSet();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
adapter.Fill(dataSet);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection.Close();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataTable tbl = dataSet.Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
List<CascadingDropDownNameValue> values =
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
new List<CascadingDropDownNameValue>();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRow dr in tbl.Rows)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string sEmployee = (string)dr["FirstName"] + " " +
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
dr["LastName"];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
int iEmployee = (int)dr["EmployeeID"];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
values.Add(new CascadingDropDownNameValue(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
sEmployee, iEmployee.ToString()));
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return values.ToArray();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
注意Web Method的参数签名是不可以改变的,并且它最后返回的是名-值对这种形式的数组。
整个完整后的Web Service如下:
完整代码
System;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Web;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Collections;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Configuration;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Collections.Generic;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Collections.Specialized;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Web.Services;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Web.Services.Protocols;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
AtlasControlToolkit;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Data;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
using
System.Data.SqlClient;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
/// <summary>
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
/// Summary description for Northwind
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
/// </summary>
[WebService(Namespace
=
"
http://tempuri.org/
"
)]
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
[WebServiceBinding(ConformsTo
=
WsiProfiles.BasicProfile1_1)]
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
public
class
Northwind : System.Web.Services.WebService
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
public Northwind () {
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//Uncomment the following line if using designed components
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//InitializeComponent();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
[WebMethod]
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public CascadingDropDownNameValue[] GetEmployees(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string knownCategoryValues, string category)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection connection = new
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection(connectionString);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlCommand command = new SqlCommand("SELECT * FROM Employees");
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection = connection;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
connection.Open();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlDataAdapter adapter = new SqlDataAdapter(command);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataSet dataSet = new DataSet();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
adapter.Fill(dataSet);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection.Close();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataTable tbl = dataSet.Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
List<CascadingDropDownNameValue> values =
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
new List<CascadingDropDownNameValue>();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRow dr in tbl.Rows)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string sEmployee = (string)dr["FirstName"] + " " +
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
dr["LastName"];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
int iEmployee = (int)dr["EmployeeID"];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
values.Add(new CascadingDropDownNameValue(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
sEmployee, iEmployee.ToString()));
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return values.ToArray();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
[WebMethod]
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public CascadingDropDownNameValue[] GetOrdersByEmployee(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string knownCategoryValues,
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string category)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
int iEmployee;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (!kv.ContainsKey("Employee") || !Int32.TryParse(kv["Employee"], out iEmployee))
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return null;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection connection = new
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection(connectionString);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlCommand command =
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
new SqlCommand("SELECT OrderID FROM Orders WHERE EmployeeID = " + iEmployee);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection = connection;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
connection.Open();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlDataAdapter adapter = new SqlDataAdapter(command);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataSet dataSet = new DataSet();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
adapter.Fill(dataSet);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection.Close();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataTable tbl = dataSet.Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRow dr in tbl.Rows)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string sOrder = dr["OrderID"].ToString();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
int iOrder = (int)dr["OrderID"];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
values.Add(new CascadingDropDownNameValue(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
sOrder, iOrder.ToString()));
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return values.ToArray();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
[WebMethod]
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public CascadingDropDownNameValue[] GetDetailsByOrder(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string knownCategoryValues,
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string category)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
int iOrder;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (!kv.ContainsKey("Order") || !Int32.TryParse(kv["Order"], out iOrder))
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return null;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection connection = new
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlConnection(connectionString);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlCommand command =
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
new SqlCommand("SELECT UnitPrice,OrderID FROM [Order Details] WHERE OrderID = " + iOrder);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection = connection;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
connection.Open();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlDataAdapter adapter = new SqlDataAdapter(command);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataSet dataSet = new DataSet();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
adapter.Fill(dataSet);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
command.Connection.Close();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
DataTable tbl = dataSet.Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRow dr in tbl.Rows)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string UnitPrice = dr["UnitPrice"].ToString();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
int intOrder = (int)dr["OrderID"];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
values.Add(new CascadingDropDownNameValue(
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
UnitPrice, intOrder.ToString()));
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return values.ToArray();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
在Web.config中设置连接信息:
<
connectionStrings
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
add
name
="ConnectionString"
connectionString
="Data Source=RJ-097;User ID=sa;Password=sa;Initial Catalog=Northwind"
providerName
="System.Data.SqlClient"
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</
connectionStrings
>
这时我们再添加CascadingDropDown控件,设置它的属性如下:
<
atlasToolkit:CascadingDropDown
ID
="CascadingDropDown1"
runat
="server"
>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
atlasToolkit:CascadingDropDownProperties
Category
="Employee"
ParentControlID
=""
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
PromptText
="Select Employee"
SelectedValue
=""
ServiceMethod
="GetEmployees"
ServicePath
="Northwind.asmx"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
TargetControlID
="ddlEmployees"
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
atlasToolkit:CascadingDropDownProperties
Category
="Order"
ParentControlID
="ddlEmployees"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
PromptText
="Select Order"
SelectedValue
=""
ServiceMethod
="GetOrdersByEmployee"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
ServicePath
="Northwind.asmx"
TargetControlID
="ddlOrders"
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
<
atlasToolkit:CascadingDropDownProperties
Category
="OrderDetail"
ParentControlID
="ddlOrders"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
PromptText
="Select OrderDetail"
SelectedValue
=""
ServiceMethod
="GetDetailsByOrder"
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
ServicePath
="Northwind.asmx"
TargetControlID
="ddlOrderDetails"
/>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
</
atlasToolkit:CascadingDropDown
>
至此,大功告成。运行后效果如下:
![](https://www.cnblogs.com/images/cnblogs_com/terrylee/Atlas_33.gif)
选择:
![](https://www.cnblogs.com/images/cnblogs_com/terrylee/Atlas_34.gif)
完整示例下载