gridview仅ASC正在进行排序

本文关键字：排序 正在进行 ASC gridview | 更新日期: 2023-09-27 18:17:28

所以我有排序工作，但它只运行升序。当我再次点击它时，它仍然在升序运行。我调试了它，sortDirection从未改变。这是我的排序代码。我研究了使用viewstate，但找不到一个干净的方法来使用它。

 private string ConvertSortDirectionToSql(SortDirection sortDirection)
{
    string newSortDirection = String.Empty;
    switch (sortDirection)
    {
        case SortDirection.Ascending:
            newSortDirection = "ASC";
            break;
        case SortDirection.Descending:
            newSortDirection = "DESC";
            break;
    }
    return newSortDirection;
}
protected void caseloads_Sorting(object sender, GridViewSortEventArgs e)
{
    DataTable dataTable = caseloads.DataSource as DataTable;
    if (dataTable != null)
    {
        DataView dataView = new DataView(dataTable);
        dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
        caseloads.DataSource = dataView;
        caseloads.DataBind();
    }
}

gridview仅ASC正在进行排序

我选择了viewstate。它将开头设置为升序，所以你甚至可以将它更改为降序，如果你想这样做的话。案件数量();是我的gridview存储和拉所有的信息。

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        ViewState["sorting"] = "Ascending";
    }
        caseLoads();
}

那么在排序中我们有if语句查找升序和降序。

 private string ConvertSortDirectionToSql(SortDirection sortDirection)
{
    string newSortDirection = String.Empty;
    string sort = Convert.ToString(ViewState["sorting"]);
    if (sort == "Ascending")
    {
        newSortDirection = "ASC";
        ViewState["sorting"] = "Descending";
    }
    else if (sort == "Descending")
    {
        newSortDirection = "DESC";
        ViewState["sorting"] = "Ascending";
    }
    return newSortDirection;
}

这是gridview排序

protected void caseloads_Sorting(object sender, GridViewSortEventArgs e)
{
    DataTable dataTable = caseloads.DataSource as DataTable;
    if (dataTable != null)
    {
        DataView dataView = new DataView(dataTable);
        dataTable = dataView.ToTable();
        dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);
    caseloads.DataSource = dataView;
    caseloads.DataBind();
    }
}

这是我在asp中使用的gridview 

<asp:GridView ID="caseloads" runat="server" AutoGenerateColumns="false" GridLines="None"
                                Font-Size="12.5px" BackColor="#FFFFFF" CssClass="mGrid"  OnSorting="caseloads_Sorting" AllowSorting="true">
                                <Columns>
                                    <asp:TemplateField HeaderText="Client ID" SortExpression="ClientKey">
                                        <ItemTemplate>
                                            <asp:Label ID="clientKey1" runat="server" Text='<%#Eval("ClientKey")%>' />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Full Name" SortExpression="ConsumerName">
                                        <ItemTemplate>
                                            <asp:Label ID="clientKey2" runat="server" Text='<%#Eval("ConsumerName")%>' />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Program" SortExpression="info">
                                        <ItemTemplate>
                                            <asp:Label ID="clientKey3" runat="server" Text='<%#Eval("info")%>' />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="House" SortExpression="phoneH">
                                        <ItemTemplate>
                                            <asp:Label ID="clientKey4" runat="server" Text='<%#Eval("phoneH")%>' />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Cell" SortExpression="phoneC">
                                        <ItemTemplate>
                                            <asp:Label ID="clientKey5" runat="server" Text='<%#Eval("phoneC")%>' />
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                </Columns>
                            </asp:GridView>
相关文章：