SPGridView: Adding paging to SharePoint when using custom data sources

Using SPGridView Filter properties

Powlo's SharePoint Treats — Tue, 15 May 2007 10:58:06 GMT

Great news everyone \o/ - a solution to setting an SPGridView filter has been researched and documented

re: Adding paging to SharePoint SPGridView when using custom data sources

RobertaRuane — Tue, 29 May 2007 16:46:43 GMT

This has been a great post - thanks

re: Adding paging to SharePoint SPGridView when using custom data sources

ArjunaK — Fri, 01 Jun 2007 18:17:13 GMT

This has been the BEST post on using SPGridView so far.

Thank you Paul!

re: Adding paging to SharePoint SPGridView when using custom data sources

Brian111 — Sun, 01 Jul 2007 23:39:54 GMT

Got this working fine. However when I put a button on the web part to fire off the create dataset bit the first page of the results are returned fine but if I then select another page the results control disappears completely. Any ideas ?

Thanks

re: Adding paging to SharePoint SPGridView when using custom data sources

Paul Robinson — Mon, 02 Jul 2007 14:56:29 GMT

sounds like an issue with the page lifecycle - is it possible you dont initialise the control properly on the callback, or dont persist the state?

re: Adding paging to SharePoint SPGridView when using custom data sources

Brian111 — Tue, 03 Jul 2007 12:29:17 GMT

Yes, thanks you were absolutly right.

On a slightly different but related subject when the CreateChildControls has a conditional set of contols on it. ie either search criteria or search results. When these are switched I am getting an error "unexpected error has occurred". I have found that whenever I add contols to the web part I need to manually change the size of the web part in the web part properties in sharepoint.

Do you know why this occurs ?

Thanks

re: Adding paging to SharePoint SPGridView when using custom data sources

Paul Robinson — Tue, 03 Jul 2007 13:33:10 GMT

sounds bizarre. off-teh-top-of-my-head I'd be thinking that changing the size is one way to invalidate the cache. Perhaps your caching is configured such that MOSS doesn't recognise the new control has been added? Just a thought.

re: Adding paging to SharePoint SPGridView when using custom data sources

Brian111 — Tue, 03 Jul 2007 23:12:31 GMT

In the menu field I have been trying to add more than one TextField and then format it appropriatly. This works fine except I can not force a carriage return between the fields. You can see how I am trying to do this below...

colMenu.TextFields = "DAV:displayname, DAV:href, Size, HitHighlightedSummary";

colMenu.TextFormat = "{0} \n {1}, Size:{2} \r\n {3}";

Do you know if it is possible ?

re: Adding paging to SharePoint SPGridView when using custom data sources

Brian111 — Tue, 03 Jul 2007 23:22:40 GMT

P.S also tried

colMenu.TextFormat = "{0}<br>{1}, Size:{2} {3}";

re: Adding paging to SharePoint SPGridView when using custom data sources

Paul Robinson — Wed, 04 Jul 2007 11:04:54 GMT

Umm - when I saw you'd tried \r\n I thought I'd recommend <br> - but apparently not! Good luck - please post if you find the answer.

re: SPGridView: Adding paging to SharePoint when using custom data sources

Brian111 — Thu, 05 Jul 2007 20:40:46 GMT

Nope never managed to solve this, It seems to take out all html coding as if using SPEncode.

Had to go back to the beginning, drop the SPGridView and biuld the results in a table. Shame as I also have to code all the paging now as well.

Still got one problem and that is it will only return up to 10 results ! Any idea why this would be. Is there a setting somewhere ?

Cheers

re: SPGridView: Adding paging to SharePoint when using custom data sources

Paul Robinson — Fri, 06 Jul 2007 11:37:13 GMT

Oh dear dear. We can't have you resorting to tables when there's a lovely SPGridView. This will not stand Brian! I'll take a look this weekend - it must be possible, right?

re: SPGridView: Adding paging to SharePoint when using custom data sources

Brian111 — Fri, 06 Jul 2007 16:06:39 GMT

Thanks, away next week so no rush and finished solution now but would be good to know for future. It beat me if it is possible ! Cheers

re: SPGridView: Adding paging to SharePoint when using custom data sources

shandao_song@hotmail.com — Wed, 01 Aug 2007 00:11:29 GMT

It is a great posting so far.

I (L) SPGridView

Mirrored Blogs — Wed, 08 Aug 2007 15:00:43 GMT

Currently I'm busy with redeveloping some 'old' 2003 webparts and quite often I used a .NET

re: SPGridView: Adding paging to SharePoint when using custom data sources

jordoman — Tue, 18 Sep 2007 13:08:46 GMT

Thanks for a very useful post. I'm having trouble creating a PagerTemplate though. Rather than a few insignificant looking numbers at the bottom of the grid it would be nice to have links kind of like:

First Prev 1 2 3 4 5 Next Last

Do you think you might have time to update with a small example?

re: SPGridView: Adding paging to SharePoint when using custom data sources

divya028 — Wed, 12 Dec 2007 12:55:30 GMT

When i use SPGridView its throws error as " Object reference not set to an instance of an object ".

But if i use Datagrid it has no issues. i dont want to use datagrid since paging is not happening in it properly. kindly help

re: SPGridView: Adding paging to SharePoint when using custom data sources

ArunDutt — Sat, 29 Dec 2007 07:46:21 GMT

Hello Paul,

Thank you for the nice article. I've tried your code and it is working. But I have a problem with the paging. I enabled the paging for the SPGridView, but the problem is the pager buttons are not visible. I really dont know what the problem is.

re: SPGridView: Adding paging to SharePoint when using custom data sources

sberger75 — Mon, 03 Mar 2008 18:18:36 GMT

Can u send me the complete source code ?

regards

re: SPGridView: Adding paging to SharePoint when using custom data sources

JayZeh — Fri, 28 Mar 2008 06:52:41 GMT

Hi,

I'm also having some problems displaying the buttons.

Were you guys able to solve this problem?

Ive created a spgridview and put it on a table cell,

the item counts are rendering properly but no paging links.

re: SPGridView: Adding paging to SharePoint when using custom data sources

lpmeunier — Tue, 13 May 2008 20:20:45 GMT

Anyone was able to find a solution to the paging buttons not displayed?

I followed this article series using the SPGridView and so far everything has worked pretty well, but i can't seem to be able to get those paging links to show up. The item limit per page does work though, just not the paging links.

Any ideas?

re: SPGridView: Adding paging to SharePoint when using custom data sources

pateketu — Fri, 06 Jun 2008 18:52:42 GMT

Good post helped me get on with Paging in SPGridView, but I wanted more custom paging style like "Page 1 of 10".

Found a solution to do that by extending SPGridViewPager

http://ketulpatel.wordpress.com/2008/06/06/custom-paging-in-spgridview-extending-spgridviewpager/

re: SPGridView: Adding paging to SharePoint when using custom data sources

Oliver Wirkus — Thu, 21 Aug 2008 15:57:02 GMT

Excellent article, Powlo - good job!

I took the infos you posted here to build an example on how to use SPGridView with sorting, paging and filtering. I was able to display the sorting-icon and filtering-icon just like we know it from sharepoint lists.

Here is the link - just in case someone is interessted :-)

http://www.sharepointblogs.com/wirkus/archive/2008/08/21/how-to-professionelle-datenanzeige-mit-dem-control-spgridview.aspx

SPGridView – sposób wykorzystania oraz ograniczenia

.neting in the free world — Wed, 24 Sep 2008 01:34:48 GMT

Nie raz już w różnych przypadkach podawałem wam linki odnoszące się do SPGridView , pora się temu trochę

re: SPGridView: Adding paging to SharePoint when using custom data sources

abis123 — Tue, 25 Nov 2008 18:23:16 GMT

Excellent blog and article. Got to be my main source of SPGridView information on the web.

Quick question, if I apply paging and write out a count of results it only displays the amount per page (not total results). Do you know a way to return a count of all results with paging activated?

re: SPGridView: Adding paging to SharePoint when using custom data sources

vmoroz — Thu, 05 Feb 2009 21:39:27 GMT

Hi,

I have built the web part with grouping an paging. The paging works just fine. But I have an issue. If I collapse the last group in last page the pager control disappears together with group rows. This is confusing our portal users. Does someone know how to let pager navigation stays on the bottom of page when last group is collapsed?

re: SPGridView: Adding paging to SharePoint when using custom data sources

lzandman — Mon, 09 Feb 2009 17:42:53 GMT

Above I read that some users have problems with their paging buttons (they don't appear). A cause for this might be that the line where you set the PagerTemplate to null is in the wrong position.

It needs to be executed AFTER the grid has been added to the Controls collection of its parent control. If this parent control itself is also contained in a control (as is often the case with composite controls), then you have to place the line with the PagerTemplate assignment after all those calls.

Example:

SPGridView _grid = new SPGridView();

Panel _panel = new Panel();

...

_panel.Controls.Add(_grid);

Controls.Add(_panel);

_grid.PagerTemplate = null;

re: SPGridView: Adding paging to SharePoint when using custom data sources

bilalfastian — Tue, 23 Jun 2009 19:55:32 GMT

Thanks for the nice Post.

I am have a problem that, every thing renders properly first time data is bound, but as soon as I change the page, data still renders correctly but the alignment of first column is disturbed. It sticks to the left margin of Grid once I navigate from the first page. Even going back to first page does not restore it.

My first column is a template field. I am not using any alignment related property with template field.

Any suggestions?