如何对YUI GridView列进行排序?我想对YUI GridView的所有列进行排序 [英] How to sort YUI GridView Columns? I want to sort all columns of YUI GridView

问题描述

我正在使用第三方YUI Grid工具.我想对该网格的列进行排序.当我单击上下文菜单时，它不起作用.以下是我的代码.我正在使用VB.NET作为背后的代码.请提出建议.谢谢.

Hi I am using a third party YUI Grid Tool. I want to sort columns of that grid. When I click on Context Menu it does not work. Following is my code. I am using VB.NET as code behind. Please suggest. thanks.

<cc1:YuiGrid ID="YUIGrid1" runat="server" title="List" Width="955px"

                            Height="425px" AutoGenerateColumns="false" ForeColor="black" AutoPostBack="False" EnableEdit="true"

                            EnablePaging="true" PageSize="50" PagingStyle="NavBar" EnableColumnMove="True" EnableDragDrop="True" EnableRowSorting="True"  >
                            <Columns>
                                <cc1:ColModel header="ID" dataIndex="ID" sortable="False" width="50" hidden="true"  />
                                <cc1:ColModel header="Code" dataIndex="Code" sortable="False" width="100" Editable="True"/>
                                <cc1:ColModel header="Inventory Code" dataIndex="InventoryCode" sortable="False" width="100" Editable="True" />
</Columns>
</cc1:YuiGrid>

推荐答案

您在这里

YUI库示例:DataTable控件:客户端排序 [ YUI数据表样式化的GridView [

Here you go

YUI Library Examples: DataTable Control: Client-side Sorting[^]

YUI DataTable Styled GridView[^]

我找到了一个解决方案，但为此我不得不打电话给数据库每次我点击列进行排序.

I found one solution but for this I have to give a call to database every time I click on column for sort.

Private Sub GetProductList(ByVal sortColumn As String, ByVal sortDir As String)
       ''Deciding sort orders
       Dim sortField As String = sortColumn
       Dim sortOrder As String = sortDir
       Dim sortOrderReverse As String = IIf(sortOrder = "ASC", "DESC", "ASC")
       Dim cn As New SqlConnection(MyConnectionString)
       Dim cm As New SqlCommand
       cn.Open()
       Try
           With cm
               .Connection = cn
               .CommandType = CommandType.Text
               Try
                   Dim sql1 As String = String.Format( _
                       "SELECT TOP 50 * FROM tabProduct ORDER BY {0} {1}", sortField, sortOrder)
                   Dim sql2 As String = String.Format( _
                       "SELECT TOP {0} * FROM ({1})as a ORDER BY {2} {3}", _
                        grdProductList.PageSize, sql1, sortField, sortOrderReverse)
                   Dim sql3 As String = String.Format( _
                       "SELECT * FROM ({0})as b ORDER BY {1} {2}", _
                        sql2, sortField, sortOrder)
                   .CommandText = sql3
                   Dim da As SqlDataAdapter = New SqlDataAdapter(sql3, cn)
                   Dim ds As New DataSet
                   da.Fill(ds, "tabProduct")
                   YUIGrid1.DataSource = ds
                   YUIGrid1.DataBind()
               Catch ex As Exception
               Finally
               End Try

           End With
       Catch ex As Exception
       End Try
       upnlProductListGrid.Update()
   End Sub
Protected Sub grdProductList_PageIndexChanged(ByVal sender As Object, ByVal e As ExtExtenders.PageIndexChangedArgs) Handles grdProductList.PageIndexChanged
      GetProductList(e.sortColumn, e.sortDir)
        End Sub

这篇关于如何对YUI GridView列进行排序?我想对YUI GridView的所有列进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！