基于用户选择而不刷新页面的RadGrid刷新

Question

在我的页面上，我有一个RadGrid (命名为RadGrid1)和一个RadComboBox (命名为Client)。这两种方法都是从SQL数据库中填充的，下面是我试图做的事情；

当用户从下拉列表中选择一个客户端时，我希望重新加载网格，witout，重新加载页面。这是网格和组合框

<div style="vertical-align: top">
    <fieldset>
        <p>
            <asp:Label ID="ClientLabel" runat="server" AssociatedControlID="Client">Client</asp:Label><telerik:RadComboBox
                ID="Client" runat="server" ValidationGroup="GetRFPIDValidationGroup" OnSelectedIndexChanged="Client_SelectedIndexChanged" />
                <p>
                <asp:RequiredFieldValidator ID="ClientRequiredValidator" runat="server" ControlToValidate="Client"
                    CssClass="failureNotification" ErrorMessage="Client is required." ToolTip="Client is required."
                    ValidationGroup="GetRFPIDValidationGroup">*</asp:RequiredFieldValidator>
            </p>
            <p>
                &nbsp;<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdateInitiatorPanelsOnly="True">
                    <AjaxSettings>
                        <telerik:AjaxSetting AjaxControlID="RadGrid1">
                            <UpdatedControls>
                                <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
                                <telerik:AjaxUpdatedControl ControlID="Client" LoadingPanelID="RadAjaxLoadingPanel1" />
                            </UpdatedControls>
                        </telerik:AjaxSetting>
                        <telerik:AjaxSetting AjaxControlID="Client">
                            <UpdatedControls>
                                <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
                            </UpdatedControls>
                        </telerik:AjaxSetting>
                    </AjaxSettings>
                </telerik:RadAjaxManager>
                <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
                </telerik:RadAjaxLoadingPanel>
                <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1">
                    <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AllowPaging="True"
                        OnNeedDataSource="RadGrid1_NeedDataSource" OnSortCommand="RadGrid1_SortCommand">
                        <MasterTableView AllowMultiColumnSorting="true">
                            <PagerStyle AlwaysVisible="true" />
                        </MasterTableView>      
                    </telerik:RadGrid>
                </telerik:RadAjaxPanel>
            </p>
    </fieldset>
</div>

下面是OnSelectedIndexChanged的RadCmboBox事件

Protected Sub Client_SelectedIndexChanged(sender As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs) Handles Client.SelectedIndexChanged
    RadGrid1.DataSource = Load(Client.SelectedItem.Text, "2014")
    RadGrid1.Rebind()
    Me.RadGrid1.MasterTableView.Rebind()
End Sub

最后是荷载法

Protected Sub RadGrid1_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
    TryCast(sender, RadGrid).DataSource = Load(Client.SelectedItem.Text, "2014")
End Sub

Public Function Load(ByVal client_id As String, ByVal year As String) As DataTable
    Using conn As New SqlConnection(SqlConn.GetConnectionString("ProLodgic"))
        Using cmd As New SqlCommand()
            With cmd
                .CommandType = CommandType.StoredProcedure
                .CommandText = "spLoadRFPIDs"
                .Parameters.AddWithValue("@ClientID", client_id)
                .Parameters.AddWithValue("@BidYear", year)
                .Connection = conn
            End With

            SqlConn.HandleConnection(conn, False)

            Using ad As New SqlDataAdapter(cmd)
                'ad.SelectCommand = cmd
                Dim table As New DataTable()
                Try

                    ad.Fill(table)
                    Return table
                Catch ex As Exception
                    ErrorMessage.Text = ex.Message
                    Return Nothing
                End Try
            End Using
        End Using
    End Using
End Function

有人对我做错了什么有任何想法。我知道我可以将AutoPostBack设置为RadComboBox上的True，但我试图阻止页面重新加载。

Answer 1

添加AutoPostBack = True完全符合我的要求，而不是我所期望的那样。

Answer 2

在从列表中选择项时，可以使用telerik Ajax管理器仅重新加载网格，以避免页面完全回发。