GridView - inital load show sorting

[snufse]

When I show a GridView for the first time I would like to show that the GridView is sorted on a specific column (Asc or Desc) (even if I have not yet clicked any sort columns). So what I do is using an "InitialLoad" variable = True and then I manually set the SortExpression and SortDirection. When user clicks on a sort column I set the "InitalLoad" = False. I don't know if there is a better way do do this?

[vuyiswamb]

In your SQL statement if you are Displaying from it , add the Order by Clause and it will order it by your Column

[snufse]

Yes, I am doing so but I want to give the user a better indication on how the grid view is sorted initially.

[mendhak]

Have a look at the sample code on this page:
http://msdn.microsoft.com/en-us/libr...xpression.aspx

It includes adding an image to indicate which direction the sort has occurred on. That is probably what you need.

There's another sample method here:
http://geekswithblogs.net/ram/archiv...sFunction.aspx

That should also take care of your 'initial load' problem, because it will always show which direction the sort is occurring on.

[snufse]

When I initially load the GridView, I call the below:

Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles GridView1.RowCreated

If e.Row.RowType = DataControlRowType.Header Then
   Dim sortColumnIndex As Integer
   sortColumnIndex = GetSortColumnIndex()

   If ViewState("InitialSort1") = True Then
      sortColumnIndex = 0
      Session("SortDirection") = "ASC"
      ViewState("SortExpression") = "CompanyJobID"
      AddSortImage(sortColumnIndex, e.Row)
  Else
      If sortColumnIndex <> -1 Then
      Session("SortDirection") = GridViewSortDirection
      AddSortImage(sortColumnIndex, e.Row)  
  End If
End If

I have 4 columns in my grid view, column 0 = companyjobid (sortable), column 1 = date (sortable), column 2 = time (non sortable, colum 3 = Text (non sortable). At initial load the grid view is sorted (asc) through my sql statement and is being shown in this order. When I call the GetSortColumnIndex()" function, the value being returned is = 2 (I do not know why, maybe because no sortcolumn is found and column 2 is the firts non sortable column in my grid?). At the initial load the program does not know about any sorting (direction or expression) because no "sort click event" been raised. This is why I control sort expression and direction manually in my code.

Now when user starts clicking on sortable columns everything is fine and works (correct column is sorted and correct image is applied (asc or desc).