Problem with Sorting datagrid .. help please

[Burak]

Hello,

I have a datagrid as follows

<asp:datagrid id="dtgIncomplete" Runat="server"
OnPageIndexChanged="PageActiveRecords" AllowPaging="True"
PageSize="25" autogeneratecolumns="false" Width="537px"
AllowSorting="True" OnSortCommand="SortCommand_OnClick">

<Columns>
<asp:BoundColumn HeaderText="VJC Ref#" SortExpression="JOB_ID"
DataField="JOB_ID" HeaderStyle-HorizontalAlign="Center"
ItemStyle-HorizontalAlign="Center"></asp:BoundColumn>

<asp:BoundColumn HeaderText="Company Job ID"
SortExpression="EMPLOYERS_JOB_ID" DataField="EMPLOYERS_JOB_ID"
HeaderStyle-HorizontalAlign="Center"
etc..
</Columns>
</asp:datagrid>

and here is my sort function

Sub SortCommand_OnClick(ByVal source As Object, ByVal e As
System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles
dtgIncomplete.SortCommand

GetActiveJobs(dtgIncomplete.CurrentPageIndex, e.SortExpression)
End Sub


Sub GetActiveJobs(ByVal index As Integer, Optional ByVal strSort As
String = "")

Dim Source As DataView = ds.Tables(0).DefaultView
If strSort = "" Then
Source.Sort = "job_id"
Else
Source.Sort = strSort
End If

'bind the data source
dtgIncomplete.DataSource = Source
dtgIncomplete.CurrentPageIndex = index
dtgIncomplete.PageSize = lstDisplay.SelectedValue
dtgIncomplete.DataBind()

End Sub

When I click on the header columns in the datagrid, it only does an
ascending sort.

How can I have it do both ascending and descending?

Thank you,

Burak

 

[Scott Mitchell [MVP]]

Burak, see:
http://aspnet.4guysfromrolla.com/articles/012903-1.aspx

Also, I discuss this in Chapter 7 of my book, ASP.NET Data Web Controls
Kick Start
[http://www.amazon.com/exec/obidos/ASIN/0672325012/4guysfromrollaco]

Happy Programming!

--

Scott Mitchell
(e-mail address removed)
http://www.4GuysFromRolla.com
http://www.ASPFAQs.com
http://www.ASPMessageboard.com

* When you think ASP, think 4GuysFromRolla.com!

 

[Saravana [MVP]]

Check out this article,
http://www.dotnetbips.com/displayarticle.aspx?id=7