使用 LinqDataSource 实现 DropDownList 联动

< asp:DropDownList  ID ="DropDownList1"  runat ="server"  DataSourceID ="LinqDataSource1"  DataValueField ="ID"  DataTextField ="Data"  AutoPostBack ="true"   />
< asp:LinqDataSource  ID ="LinqDataSource1"  runat ="server"  OnSelecting ="LinqDataSource1_Selecting"   />

< asp:DropDownList  ID ="DropDownList2"  runat ="server"  DataSourceID ="LinqDataSource2"  DataValueField ="ID"  DataTextField ="Data"   />
< asp:LinqDataSource  ID ="LinqDataSource2"  runat ="server"  OnSelecting ="LinqDataSource2_Selecting"  Where ="pID == @pID" >
  < WhereParameters >
    < asp:ControlParameter  Name ="pID"  ControlID ="DropDownList1"  PropertyName ="SelectedValue"  Type ="int32"   />
  </ WhereParameters >

</ asp:LinqDataSource >

 

protected   void  LinqDataSource1_Selecting( object  sender, LinqDataSourceSelectEventArgs e)
{

    e.Result  =  from i  in   new [] {  new  { ID  =   1 , Data  =   " Key 1 "  },  new  { ID  =   2 , Data  =   " Key 2 "  } } select i;
}

protected   void  LinqDataSource2_Selecting( object  sender, LinqDataSourceSelectEventArgs e)
{

    e.Result  =  from i  in   new [] {  new  { ID  =   1 , Data  =   " Value 1 " , pID  =   1  },  new  { ID  =   2 , Data  =   " Value 2 " , pID  =   1  },  new  { ID  =   3 , Data  =   " Value 3 " , pID  =   2  } } select i;
}