如何对YUI GridView列进行排序?我想对YUI GridView的所有列进行排序 [英] How to sort YUI GridView Columns? I want to sort all columns of YUI GridView
本文介绍了如何对YUI GridView列进行排序?我想对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屋!
查看全文