ansaurus

Question

Why doesn't my gridview's column click toggle the sort direction?

Answer 1

A:

I think you'll find your answer in the many replies to this similar question.

I believe that if you use the simplest version, ASP.Net will handle the whole sorting thing for you.

This code from a SqlDataSource example just sets AllowSorting="true" and provides SortExpressions in BoundColumns. It has no wiring up of the OnSorting event, and no other code. I believe it manages the toggling between ASC and DESC for you. In this case, using the dreaded SqlDataSource, I believe you have to use a DataSet and not a DataReader.

<%@ Page Language="C#" %>
<html>
<head id="Head1" runat="server">
  <title>Sorting Data Using GridView</title>
</head>
<body>
  <form id="form1" runat="server">
   <asp:GridView ID="GridView1" AllowSorting="true" runat="server" DataSourceID="SqlDataSource1"
      AutoGenerateColumns="False">
      <Columns>
        <asp:BoundField HeaderText="ID" DataField="au_id" SortExpression="au_id" />
        <asp:BoundField HeaderText="Last Name" DataField="au_lname" SortExpression="au_lname" />
        <asp:BoundField HeaderText="First Name" DataField="au_fname" SortExpression="au_fname" />
        <asp:BoundField HeaderText="Phone" DataField="phone" SortExpression="phone" />
        <asp:BoundField HeaderText="Address" DataField="address" SortExpression="address" />
        <asp:BoundField HeaderText="City" DataField="city" SortExpression="city" />
        <asp:BoundField HeaderText="State" DataField="state" SortExpression="state" />
        <asp:BoundField HeaderText="Zip Code" DataField="zip" SortExpression="zip" />
        <asp:CheckBoxField HeaderText="Contract" SortExpression="contract" DataField="contract" />
      </Columns>
    </asp:GridView>
   <asp:SqlDataSource ID="SqlDataSource1" runat="server"
      SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract] FROM [authors]"
      ConnectionString="<%$ ConnectionStrings:Pubs %>" />
  </form>
</body>
</html>

DOK 2009-04-05 18:51:59

in other words, its not done automatically...

Blankman 2009-04-05 19:04:32

I believe it can be done automatically if you set it up just right. For one thing, I don't think you need to set the OnSorting event or add code in it. But I think you might need to add BoundColumns with SortExpressions defined. Then, it's supposed to do the toggling between ASC and DESC for you.

DOK 2009-04-05 19:46:45

ansaurus

tags:

views:

answers:

Why doesn't my gridview's column click toggle the sort direction?

related questions