GridView Sorting Problem - .NET Framework

7 New Member

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 Reply

2340

jhardman

3,406

Recognized Expert Specialist

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

Jared, moderator
ASP forum

Jul 30 '07 #2

Similar topics

2736

Gridview, using Callbacks when Sorting and Paging

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 not the whole page, but a portion of the page. Strangely enough the URL below http://beta.asp.net/QUICKSTARTV20/aspnet/doc/ctrlref/data/gridview.aspx (VB GridView Paging and Sorting Callbacks example)

.NET Framework

3377

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 in the database when the user press a "View All" button. In this case, I need to change the select comand and clear the parameters. And I did this in the button_click() event. the GridView can display desired results when I press the "View All"...

ASP.NET

8252

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 = ds gvUsers.DataBind()

ASP.NET

5481

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 an eventhandler thus: Protected Sub grdResult_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles grdResult.Sorting

ASP.NET

1769

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

3816

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 in my 'onpageload' in the cs file.

C# / C Sharp

11163

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 ReportTable As System.Data.DataTable = New System.Data.DataTable("SendTo") The ReportTable is populated row by row by data gotten back from the

ASP.NET

1385

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 Server Error in '/' Application. -------------------------------------------------------------------------------- The data source 'objdsDataSource' does not support sorting with IEnumerable data. Automatic sorting is only supported with...

.NET Framework

1534

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 the Gridview control also .Actually I am able to bind the sql datasource control to the Gridview on button Click but on clicking the GridView for paging or sorting , the Gridview vanishes!! In short, I want to bind the GridView control to a...

ASP.NET

2025

Problem with binding Gridview to sqldatasource control

by: Sobin Thomas | last post by:

ASP.NET

9666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10413

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10200

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9986

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9021

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5422

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4094

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3707

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General