的Gridview

的Gridview

关注
发信
关注(28)粉丝(399)

ASP.NET的GridView与级联下拉控件刷新

本文介绍了ASP.NET的GridView与级联下拉控件刷新的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有两个下拉列表，并在一个asp.net页面的GridView（lstDivisions，lstDistricts，gridIncidents），我使用的SqlDataSource ID报表ASPX页面检索从SQL Server中的数据为所有三个控件。

所有的控件加载正确的，当我在第二个下拉菜单中选择不同的值在GridView填充预期。

当我选择第一个下拉第二个下拉正确填充新科值，但在GridView不会刷新，直到我从第二个下拉列表中选择新会区值。

用什么方法做我用它来刷新GridView的？

感谢

从aspx页面code：

 ＆LT; ASP：SqlDataSource的ID =sourceIncidents=服务器的ProviderName =System.Data.SqlClient的
     的ConnectionString =下;％$的ConnectionStrings：DB1Connection％＆gt;中
     的SelectCommand =SELECT incidentnumber，call_date，call_time，地址，CALL_TYPE，区，距离事故ORDER BY CREATE_DATE
     FilterEx pression =区='{0}'EnableCaching =真＆GT;
     ＆LT; FilterParameters＆GT;
       ＆LT; ASP：ControlParameter控件ID =lstDistrictsNAME =区属性名=的SelectedValue/＆GT;
     ＆LT; / FilterParameters＆GT;
    ＆LT; / ASP：SqlDataSource的＆GT;    ＆LT; ASP：SqlDataSource的ID =sourceIncidentDistricts=服务器
     的ProviderName =System.Data.SqlClient的的ConnectionString =＆LT;％$的ConnectionStrings：的DB2Connection％＆gt;中
     的SelectCommand =SELECT DivisionName，DistrictName作为区，距离LEFT JOIN区分部ON Districts.DivisionID = Divisions.DivisionID
     FilterEx pression =DivisionName ='{0}'EnableCaching =真＆GT;
     ＆LT; FilterParameters＆GT;
       ＆LT; ASP：ControlParameter控件ID =lstDivisionsNAME =DivisionName属性名=的SelectedValue/＆GT;
     ＆LT; / FilterParameters＆GT;
    ＆LT; / ASP：SqlDataSource的＆GT;    ＆LT; ASP：SqlDataSource的ID =sourceIncidentDivisions=服务器
     的ProviderName =System.Data.SqlClient的的ConnectionString =＆LT;％$的ConnectionStrings：的DB2Connection％＆gt;中
     的SelectCommand =SELECT DISTINCT DivisionName FROM师EnableCaching =真＆GT;
    ＆LT; / ASP：SqlDataSource的＆GT;
    ＆LT; BR /＆GT;    ＆LT; ASP：标签ID =lblDivision=服务器文本=司＆GT;＆LT; / ASP：标签＆gt;
    ＆LT; ASP：DropDownList的ID =lstDivisions=服务器的DataSourceID =sourceIncidentDivisions
        DataValueField =DivisionNameOnSelectedIndexChanged =GetDivisions_SelectedIndexChanged
        DataTextField =DivisionNameWIDTH =205px的AutoPostBack =真＆GT;
    ＆LT; / ASP：DropDownList的＆GT;    ＆安培; NBSP;＆安培; NBSP;＆安培; NBSP;＆安培; NBSP;＆安培; NBSP;
    ＆LT; ASP：标签ID =lblDistrict=服务器文本=区＆GT;＆LT; / ASP：标签＆gt;
    ＆LT; ASP：DropDownList的ID =lstDistricts=服务器的DataSourceID =sourceIncidentDistricts
       DataValueField =区OnSelectedIndexChanged =GetDistricts_SelectedIndexChanged
       DataTextField =区WIDTH =205px的AutoPostBack =真＆GT;
    ＆LT; / ASP：DropDownList的＆GT;＆LT; BR /＆GT;
    ＆LT; BR /＆GT;
    ＆LT; ASP：标签ID =lblIncidentsCaption=服务器FONT-粗体=真FONT-名称=宋体
        字体大小=小＆GT;＆LT; / ASP：标签＆gt;
    ＆LT; BR /＆GT;    ＆LT; ASP：GridView控件ID =gridIncidents=服务器的cellpadding =3的DataSourceID =sourceIncidents
        字体名称=宋体FONT-SIZE =小
        OnSelectedIndexChanged =gridIncidents_SelectedIndexChanged
        网格线=水平的AutoGenerateColumns =FALSE的DataKeyNames =incidentnumber
        AllowPaging =真AllowSorting =真背景色=白BORDERCOLOR =＃4A3C8C
        边框样式=无边框宽度=1像素
        PagerSettings模式=NumericFirstLastPagerSettings-位置=TopAndBottom＆GT;
        ＆LT; FooterStyle背景色=＃B5C7DE前景色=＃4A3C8C/＆GT;
        ＆LT; RowStyle的BackColor =＃E7E7FF前景色=＃4A3C8C/＆GT;
        ＆LT; PagerStyle背景色=＃E7E7FF前景色=＃4A3C8CHorizo​​ntalAlign =中心/＆GT;
        ＆LT; SelectedRowStyle背景色=＃738A9CFONT-粗体=真前景色=＃F7F7F7/＆GT;
        ＆LT; HeaderStyle背景色=＃4B6C9EFONT-粗体=真前景色=＃F7F7F7/＆GT;
        ＆LT; AlternatingRowStyle背景色=＃F7F7F7/＆GT;
        ＆LT;柱体和GT;
            ＆LT; ASP：CommandField中SelectText =＆gt;中ShowSelectButton =真/＆GT;            ＆LT; ASP：的TemplateField的HeaderText =九一八事变SORTEX pression =incidentnumber＆GT;
                ＆LT;＆ItemTemplate中GT;＆LT;％＃的eval（incidentnumber）的ToString（）％方式＆gt;＆LT; / ItemTemplate中＆GT;
                ＆LT; ItemStyle边框宽度=1px的/＆GT;
            ＆LT; / ASP：的TemplateField＆GT;
            ＆LT; ASP：的TemplateField的HeaderText =DATESORTEX pression =call_date＆GT;
                ＆LT;＆ItemTemplate中GT;＆LT;％＃的eval（call_date，{0：MM / DD / YYYY}）％GT;＆LT; / ItemTemplate中＆GT;
                ＆LT; ItemStyle边框宽度=1px的/＆GT;
            ＆LT; / ASP：的TemplateField＆GT;
            ＆LT; ASP：的TemplateField的HeaderText =TIMESORTEX pression =call_time＆GT;
                ＆LT;＆ItemTemplate中GT;＆LT;％＃的eval（call_time）％＆GT;＆LT; / ItemTemplate中＆GT;
                ＆LT; ItemStyle边框宽度=1px的/＆GT;
            ＆LT; / ASP：的TemplateField＆GT;
            ＆LT; ASP：的TemplateField的HeaderText =ADDRESSSORTEX pression =地址＆GT;
                ＆LT;＆ItemTemplate中GT;＆LT;％＃的eval（地址）％GT;＆LT; / ItemTemplate中＆GT;
                ＆LT; ItemStyle WIDTH =300像素边框宽度=1px的/＆GT;
            ＆LT; / ASP：的TemplateField＆GT;
            ＆LT; ASP：的TemplateField的HeaderText =呼叫类型SORTEX pression =CALL_TYPE＆GT;
                ＆LT;＆ItemTemplate中GT;＆LT;％＃的eval（CALL_TYPE）％＆GT;＆LT; / ItemTemplate中＆GT;
                ＆LT; ItemStyle边框宽度=1px的/＆GT;
            ＆LT; / ASP：的TemplateField＆GT;
            ＆LT; ASP：的TemplateField的HeaderText =区SORTEX pression =区＆GT;
                ＆LT;＆ItemTemplate中GT;＆LT;％＃的eval（区）％GT;＆LT; / ItemTemplate中＆GT;
                ＆LT; ItemStyle边框宽度=1px的/＆GT;
            ＆LT; / ASP：的TemplateField＆GT;
        ＆LT; /专栏＆GT;
    ＆LT; / ASP：GridView的＆GT;


解决方案

解决方案

在OnSelectedIndexChanged为 lstDivisions DropDownList的补充： lstDistricts.DataBind（）;

I have two dropdowns and a gridview (lstDivisions, lstDistricts, gridIncidents) in an asp.net page and I use SqlDataSource ID statements in the ASPX page to retrieve the data from SQL Server for all three controls.

All controls load properly and when I select a different value in the second dropdown the gridview populates as expected.

When I select a new Division value in the first dropdown the second dropdown populates properly BUT the gridview does not refresh UNTIL I select a new District value from the second dropdown.

What method do I use to Refresh the gridview?

Thanks

Code from aspx page:

<asp:SqlDataSource ID="sourceIncidents" runat="server" ProviderName="System.Data.SqlClient"
     ConnectionString="<%$ ConnectionStrings:DB1Connection %>"
     SelectCommand="SELECT incidentnumber, call_date, call_time, address , call_type, district FROM Incident ORDER BY create_date"
     FilterExpression="District='{0}'" EnableCaching="True">
     <FilterParameters>
       <asp:ControlParameter ControlID="lstDistricts" Name="district" PropertyName="SelectedValue" />
     </FilterParameters>
    </asp:SqlDataSource>

    <asp:SqlDataSource ID="sourceIncidentDistricts" runat="server"
     ProviderName="System.Data.SqlClient" ConnectionString="<%$ ConnectionStrings:DB2Connection %>"
     SelectCommand="SELECT DivisionName, DistrictName as District FROM Divisions LEFT JOIN Districts ON Districts.DivisionID = Divisions.DivisionID"
     FilterExpression="DivisionName ='{0}'" EnableCaching="True">
     <FilterParameters>
       <asp:ControlParameter ControlID="lstDivisions" Name="DivisionName" PropertyName="SelectedValue" />
     </FilterParameters>
    </asp:SqlDataSource>

    <asp:SqlDataSource ID="sourceIncidentDivisions" runat="server"
     ProviderName="System.Data.SqlClient" ConnectionString="<%$ ConnectionStrings:DB2Connection %>"
     SelectCommand="SELECT DISTINCT DivisionName FROM Divisions" EnableCaching="True">
    </asp:SqlDataSource>
    <br />

    <asp:Label ID="lblDivision" runat="server" Text="Division"></asp:Label>
    <asp:DropDownList ID="lstDivisions" runat="server" DataSourceID="sourceIncidentDivisions"
        DataValueField="DivisionName" OnSelectedIndexChanged="GetDivisions_SelectedIndexChanged"
        DataTextField="DivisionName" Width="205px" AutoPostBack="True">
    </asp:DropDownList>

    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="lblDistrict" runat="server" Text="District"></asp:Label>
    <asp:DropDownList ID="lstDistricts" runat="server" DataSourceID="sourceIncidentDistricts"
       DataValueField="District" OnSelectedIndexChanged="GetDistricts_SelectedIndexChanged"
       DataTextField="District" Width="205px" AutoPostBack="True">
    </asp:DropDownList><br />
    <br />
    <asp:Label ID="lblIncidentsCaption" runat="server" Font-Bold="True" Font-Names="Verdana"
        Font-Size="Small"></asp:Label>
    <br />

    <asp:GridView ID="gridIncidents" runat="server" CellPadding="3" DataSourceID="sourceIncidents"
        Font-Names="Verdana" Font-Size="Small"
        OnSelectedIndexChanged="gridIncidents_SelectedIndexChanged"
        GridLines="Horizontal" AutoGenerateColumns="False" DataKeyNames="incidentnumber"
        AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#4A3C8C"
        BorderStyle="None" BorderWidth="1px"
        PagerSettings-Mode="NumericFirstLast" PagerSettings-Position="TopAndBottom" >
        <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
        <HeaderStyle BackColor="#4B6C9E" Font-Bold="True" ForeColor="#F7F7F7" />
        <AlternatingRowStyle BackColor="#F7F7F7" />
        <Columns>
            <asp:CommandField SelectText=">" ShowSelectButton="True"  />

            <asp:TemplateField HeaderText="INCIDENT" SortExpression="incidentnumber">
                <ItemTemplate><%# Eval("incidentnumber").ToString() %></ItemTemplate>
                <ItemStyle BorderWidth="1px" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="DATE" SortExpression="call_date">
                <Itemtemplate><%# Eval("call_date", "{0:MM/dd/yyyy}")%></Itemtemplate>
                <ItemStyle BorderWidth="1px" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="TIME" SortExpression="call_time">
                <Itemtemplate><%# Eval("call_time") %></Itemtemplate>
                <ItemStyle BorderWidth="1px" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="ADDRESS" SortExpression="address">
                <Itemtemplate><%# Eval("address") %></Itemtemplate>
                <ItemStyle Width="300px" BorderWidth="1px" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="CALL TYPE" SortExpression="call_type">
                <Itemtemplate><%# Eval("call_type") %></Itemtemplate>
                <ItemStyle BorderWidth="1px" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="DISTRICT" SortExpression="district">
                <Itemtemplate><%# Eval("district")%></Itemtemplate>
                <ItemStyle BorderWidth="1px" />
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
解决方案

Solution

In the OnSelectedIndexChanged for the lstDivisions DropDownList added: lstDistricts.DataBind();

这篇关于ASP.NET的GridView与级联下拉控件刷新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

08-24 16:36
Powered by LMLPHP ©2024 的Gridview 0.040332