【Asp.Net从零开始】：下拉菜单选择性输出数据(DropDownList,SqlDataSource,GridView)

最新推荐文章于 2022-03-25 11:45:56 发布

weixin_30752699

最新推荐文章于 2022-03-25 11:45:56 发布

阅读量98

点赞数

原文链接：http://www.cnblogs.com/VortexPiggy/archive/2012/08/13/2635959.html

版权

<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
            DataSourceID="SqlDataSource1" DataTextField="FirstName" DataValueField="CustID">
        </asp:DropDownList>
    
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:AutoLotConnectionString %>" 
        SelectCommand="SELECT [FirstName], [CustID] FROM [Customers]">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:AutoLotConnectionString %>" 
        SelectCommand="SELECT * FROM [Customers] WHERE ([CustID] = @CustID)">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="CustID" 
                PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        CellPadding="4" DataKeyNames="CustID" DataSourceID="SqlDataSource2" 
        ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        <Columns>
            <asp:BoundField DataField="CustID" HeaderText="CustID" ReadOnly="True" 
                SortExpression="CustID" />
            <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="LastName" 
                SortExpression="LastName" />
        </Columns>
        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#E9E7E2" />
        <SortedAscendingHeaderStyle BackColor="#506C8C" />
        <SortedDescendingCellStyle BackColor="#FFFDF8" />
        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
    </asp:GridView>
    </form>
</body>

转载于:https://www.cnblogs.com/VortexPiggy/archive/2012/08/13/2635959.html

weixin_30752699

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
【Asp.Net从零开始】：下拉菜单选择性输出数据(DropDownList,SqlDataSource,GridView)

<body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDat...
复制链接

扫一扫