How to sort YUI GridView Columns? I want to sort all columns of YUI GridView

Question

0.00/5 (No votes)

See more:

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.

XML

<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>

Posted 20-Apr-11 1:49am

krypsn

Updated 20-Apr-11 6:46am

thatraja

v4

Add a Solution

Comments

Sandeep Mewara 20-Apr-11 10:10am

Did you try at the thrid party forum?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2011-04-20T06:45:00

Solution 1

Here you go

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

YUI DataTable Styled GridView[^]

Posted 20-Apr-11 6:45am

thatraja

Comments

krypsn 22-Apr-11 0:43am

Thanks for your suggestion. But i already visited these sites.

First Site:- As I told, I am using VB.NET and this site provides code in C#. I tried to convert this code in VB.NET but fails.

Second Site:- The example given in this site, is for normal ASP GridView. I want the same coding for YUI Grid. In that site they used "protected void GvCustomers_RowDataBound(object sender, GridViewRowEventArgs e)" event for sorting, but no such method is available for YUI Grid.

krypsn · Answer 2 · 2011-04-26T00:21:00

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