该小应用实现通过选择dropdownlist,在girdview上面显示特定的数据。代码如下:
1
<
asp:SqlDataSource
ID
="Type"
runat
="server"
ProviderName
="System.Data.SqlClient"
2 ConnectionString ="<% $ConnectionStrings:testDemon %>"
3 SelectCommand ="GetType" SelectCommandType ="StoredProcedure" >
4 </ asp:SqlDataSource >
5
6 < asp:DropDownList runat ="server" DataSourceID ="Type" DataValueField ="Type"
7 AutoPostBack ="true" ID ="dropType" ></ asp:DropDownList >
8
9 < asp:SqlDataSource ID ="Info" runat ="server" ProviderName ="System.Data.SqlClient"
10 ConnectionString ="<% $ConnectionStrings:testDemon %>" SelectCommand ="getTicketInfo"
11 SelectCommandType ="StoredProcedure" >
12 < SelectParameters >
13 < asp:ControlParameter ControlID ="dropType" Name ="TypeId" PropertyName ="SelectedValue" />
14 </ SelectParameters >
15 </ asp:SqlDataSource >
16
17 < asp:GridView runat ="server" DataSourceID ="Info" ></ asp:GridView >
2 ConnectionString ="<% $ConnectionStrings:testDemon %>"
3 SelectCommand ="GetType" SelectCommandType ="StoredProcedure" >
4 </ asp:SqlDataSource >
5
6 < asp:DropDownList runat ="server" DataSourceID ="Type" DataValueField ="Type"
7 AutoPostBack ="true" ID ="dropType" ></ asp:DropDownList >
8
9 < asp:SqlDataSource ID ="Info" runat ="server" ProviderName ="System.Data.SqlClient"
10 ConnectionString ="<% $ConnectionStrings:testDemon %>" SelectCommand ="getTicketInfo"
11 SelectCommandType ="StoredProcedure" >
12 < SelectParameters >
13 < asp:ControlParameter ControlID ="dropType" Name ="TypeId" PropertyName ="SelectedValue" />
14 </ SelectParameters >
15 </ asp:SqlDataSource >
16
17 < asp:GridView runat ="server" DataSourceID ="Info" ></ asp:GridView >