GridView Sorting Problem

I used this example straight from msdn in a gridview that already sorts based on each column. For some reason I cannot get it to sort based on two sorting expressions.Is there some property of the grid view i have to set in order for this to work?

Expand|Select|Wrap|Line Numbers

 <%@ Page language="C#" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
 
  void SortButton_Click(Object sender, EventArgs e)

  {
 
    String expression = "";

    SortDirection direction;
 
    // Create the sort expression from the values selected 

    // by the user from the DropDownList controls. Multiple

    // columns can be sorted by creating a sort expression

    // that contains a comma-separated list of field names.

    expression = SortList1.SelectedValue + "," + SortList2.SelectedValue;
 
    //  Determine the sort direction. The sort direction

    // applies only to the second column sorted.

    switch (DirectionList.SelectedValue)

    {

      case "Ascending":

        direction = SortDirection.Ascending;

        break;

      case "Descending":

        direction = SortDirection.Descending;

        break;

      default:

        direction = SortDirection.Ascending;

        break;

    }
 
    // Use the Sort method to programmatically sort the GridView

    // control using the sort expression and direction.

    CustomersGridView.Sort(expression, direction);
 
  }
 
</script>
 
<html  >

  <head runat="server">

    <title>GridView Sort Example</title>

</head>

<body>

    <form id="form1" runat="server">
 
      <h3>GridView Sort Example</h3>
 
      <table>

        <tr>

          <td>

             Sort by:

            <asp:dropdownlist ID="SortList1"

              runat="server">

              <asp:listitem Selected="true">CustomerID</asp:listitem>

              <asp:listitem>CompanyName</asp:listitem>

              <asp:listitem>Address</asp:listitem>

              <asp:listitem>City</asp:listitem>

              <asp:listitem>PostalCode</asp:listitem>

              <asp:listitem>Country</asp:listitem>

            </asp:dropdownlist>

          </td>

          <td colspan="2">

            &nbsp;

          </td>

        </tr>

        <tr>

          <td>

            Then by:

              <asp:dropdownlist ID="SortList2"

                runat="server">

                <asp:listitem Selected="true">CustomerID</asp:listitem>

                <asp:listitem>CompanyName</asp:listitem>

                <asp:listitem>Address</asp:listitem>

                <asp:listitem>City</asp:listitem>

                <asp:listitem>PostalCode</asp:listitem>

                <asp:listitem>Country</asp:listitem>

              </asp:dropdownlist>

          </td>

          <td>

             Sort order:      

          </td>

          <td>

            <asp:radiobuttonlist id="DirectionList"

              runat="server">

              <asp:listitem selected="true">Ascending</asp:listitem>

              <asp:listitem>Descending</asp:listitem>

            </asp:radiobuttonlist>

          </td>

        </tr>

      </table>
 
      <asp:button id="SortButton"

        text="Sort"

        onclick="SortButton_Click" 

        runat="Server"/>  
 
      <br/>

      <hr/>

      <br/>
 
      <asp:gridview id="CustomersGridView" 

        datasourceid="CustomersSource" 

        autogeneratecolumns="true"

        emptydatatext="No data available." 

        allowpaging="true" 

        runat="server">

      </asp:gridview>
 
      <!-- This example uses Microsoft SQL Server and connects  -->

      <!-- to the Northwind sample database. Use an ASP.NET     -->

      <!-- expression to retrieve the connection string value   -->

      <!-- from the Web.config file.                            -->

      <asp:sqldatasource id="CustomersSource"

        selectcommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"

        connectionstring="<%$ ConnectionStrings:NorthWindConnectionString%>" 

        runat="server"/>
 
    </form>

  </body>

</html>

Jul 27 '07 #1

Subscribe Post Reply

2312

jhardman

3,406

Expert 2GB

moved to .NET forum. There is no such thing as a gridView in ASP classic.

Jared, moderator
ASP forum

Jul 30 '07 #2

by: ck388 | last post by:

For some reason when I enable the callback feature of the gridview I still get a page refresh, that is it seems like there is a postback that occurs, not a callback which is just supposed to update...

.NET Framework

Gridview Sorting and Paging problem

by: yefei | last post by:

In my web design, I display records from a SQL DataBase according to some filters the GridView is defined with select commands and selest parameters however, I also want to display all records...

ASP.NET

GridView - Manual sorting

by: samb | last post by:

When I use manual databinding to a GridView control, as bellow. 'Retrive a DataSet from database Dim ds As DataSet = uda.GetUsers(conectionString) 'gvUsers - The GridView gvUsers.DataSource...

ASP.NET

Manually sorting a gridview, am I plain stupid?

by: kurt sune | last post by:

I have a an aspx page with a gridview. The gridview is data bound to a generic list of custom classes. The gridview's DataSource is thus not set. Now I want to add sorting to it. So I create...

ASP.NET

GridView Sorting Issue

by: jobo | last post by:

Hey there, I'm having a problem getting sorting to work. Here's what the GridView looks like: "server" ID="updt1" Mode="Conditional">

ASP.NET

Keeping sort order on a Gridview while another is sorted.

by: Cindy Lee | last post by:

When I do a sorta on 1 table, then the other table goes back to the original order. What can I set so, it keeps the order of the other current gridview's order. I set all the gridview values...

C# / C Sharp

GridView sorting

by: =?Utf-8?B?R2VyaGFyZA==?= | last post by:

I have a vb.net 2.0 app that is loading a GridView with a DataSource that is returned from a function. The definitions in the function are: Dim ReportDS As DataSet = New DataSet Dim...

ASP.NET

Sorting on GridView

by: mahesh123 | last post by:

Hi, I am using gridview in my form and binded the gridview with object datasource.I am trying to implement sorting for my grid view and i am getting following error.i am using asp.net with VB ...

.NET Framework

Binding Gridview with Sqldatasource control

by: Sobin Thomas | last post by:

Hi All, How can I bind the Gridview control to Sql Datasource control on a button click(I see majority of the articles binding datasource at page load) I need to enable the paging and sorting of...

ASP.NET

Problem with binding Gridview to sqldatasource control

by: Sobin Thomas | last post by:

Hi All, How can I bind the Gridview control to Sql Datasource control on a button click(I see majority of the articles binding datasource at page load) I need to enable the paging and sorting of...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics