Can I also put my 2 cents here ?

I posted an article on how to get a GridView do automatic paging programmatically (i.e. at run time) au lieu of declaratively (at design time).

However this method uses a ObjectDataSource (but NOT in design time).

You'll find the article here : http://forums.asp.net/thread/1554769.aspx.

Please feel free to comment !

Erwin

First, thanks for the code to get started here, Ryan.  It's helped greatly.  I'm having some issues with the Paging, though.

My GridView is populated via a DataSet (actually, I set the DataSource to the first table in the DataSet).  I grab this DataSet via Remoting.  My problem is this, the GridView will be re-bound to a new DataSet based on some search criteria on the same page.  So, what I did was create a private global DataSet.  When I grab a new DataSet from the server, I assign it to the global object then re-bind that to the GridView's DataSource.  I've pretty much used all of the code you have in the Strong Coders link (sans the populate method, of course).  The one thing I do differently is substitute the global DataSet.Tables(0) in for the GridView's DataSource in the SortDataTable function.

The problem is, when I click on the link for another page in the GridView, I lose the paging footer.  It moves to the next page, but the paging information is gone.  Any ideas here?

Hi StrongTypes,

I've come across this post as I am trying to sort my grid view. It's been a year since you've made the post so I hope you can still help!

I have a data table which populates a datagrid. I understand that I need to create a dataview. I am trying to sort one of the columns in DESCENDING order. Here is my code so far:

1    Dim dt As New Data.DataTable
2    dt = ViewState("GV1")        
3    Dim dataView As New Data.DataView(dt)
4    
5    Dim s As SortDirection
6    s = SortDirection.Descending
7    dataView.Sort = String.Format("{0} {1}", e.SortExpression, s)
8    
9    GV1.DataSource = dt
10   GV1.DataBind()

 On line 7 I get an error telling me that "there is no column named price descending", where price is the column I am trying to sort in descending order.

Can you help?

Thanks

Hi I am using a SqlDataReader as dataSource.

Is it possible to adapt the code?

If I try to use the code on the first page I always get dataTable=null.

must i use a datatable necessarily? 

Thank you for help. 

Hi ,

Not sure if this is the right thread for this but here we go

 I am trying to use the PageDataSource class and i do not wish to bind to a control, I want to be able to acees the data manually

i have searched far and wide and came up with this code

 This code works but always returns the first row of data, and as can be seen i wish to get the 4th item,

Can anyone show me the error of my ways...??

Hello Ryan,

I am using your VB.net code for sorting and paging my gridview and I can't get it done. It displays the first 25 items but when I click on sorting or paging, I get  my "EmptyDataText" No Record Found message. I know there is more data to display. My data source comes from a SQL server. I don't know what else I should specify for the moment. Here is my complete code.

I thank you very much in advance for any help!

hi, reyan ....

i m facing when i m implement this code on my application.....it gives error that unable to find  " ASC " column 

Ryan,

When I click on the Page object button I see this function get called GridView_PageIndexChanging(Ojbect sender, GridViewPageEventArgs e)

{

Let me preface this by - Like donjuanwu... my gridview disappears when I click any header - HOWEVER, I am not using any paging, my business did not request paging, they prefer to scroll down the page. 

Please help me with the 2 following strings....

This is how they appear in your post: 

private string GridViewSortDirection

    {

        get { return ViewState["SortDirection"] as string ?? "ASC"; }

        set { ViewState["SortDirection"] = value; }

    }

For my application, I have to translate them to Visual Basic

So they look like this:

Private Property GridViewSortDirection() As String
 Get
          Return ViewState("SortDirection") as String ?? "ASC"
 End Get
 Set (ByVal Value As String)
          ViewState("SortDirection") = value
 End Set
End Property
 
 
 
    Private Property GridViewSortBLOCKED EXPRESSION As String
     Get
          Return ViewState("SortBLOCKED EXPRESSION as String ?? String.Empty
     End Get
     Set (ByVal Value As String)
          ViewState("SortBLOCKED EXPRESSION = value
     End Set
    End Property
 

 I get a blue squiggly line under both of these --------> String ?? "ASC"   and   as String ?? String.Empty

"End of Statement Expected"

But clearly you are running this code as is.... what do I need to do to adjust them so they work for me? 

I have successfully translated the other necessary components.

StrongTypes:

Here's the live working example with source code: GridView Sorting/Paging w/o a DataSourceControl DataSource

I had to tweak the code a little to make sorting work in both directions.

Enjoy.
Ryan

This is almost exactly what I am looking for, is this possible via stored procedures too? 

Hi,

I applied the code which you wrote it,There are no Errors but the Sorting failed.

Att1. I am using Microsoft Enterprise Library.

Att2.I am working as NTier and my code available on Data Access Layer.

Can you help me in this regards.

Thank you in advance

The new code worked well. If the datasource is not from database, then we have to use one line of code to add the grid's datasource into viewstate.

ViewState["gridview_DataSource"] = gridview.DataSource;

And later, whereever datatable is needed, add this line of code.

test