SPGridView with (SPGridViewPager && Grouping) + SPGridView with (Totals && Counts)

Question

I need to have SPGridView with Totals and Counts how can i set that up? I dont even know where to start...

I have Sorting&Filtering and Grouping and also paging but if i try the SPGridViewPager i get an ArgumentNullExp in container.

Can anyone help me on there two issues?

---

http://pontodepartilha.blogspot.com

Answer 1

Hi, 

Where you need you SPGridview, "WebPart","ASPX Page" have connection to Other Database?

here a nice example:

http://blogs.msdn.com/powlo/archive/2007/02/25/displaying-custom-data-through-sharepoint-lists-using-spgridview-and-spmenufield.aspx

Can you use Sharepoint Designer "Data view>Manage Data sources" there you can make connection to SQL and other database and use the Datasources, or want to create a WSP file, to create your custom code. 

 

Hope this help....

---

André Lage Microsoft SharePoint and CRM Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/

Answer 2

Thanks for the help, i have already done that, i have a custom aspx with an custom webpart and inside i have spgridview getting data from external sql. In this post : http://blogs.msdn.com/powlo/archive/2007/03/23/adding-paging-to-spgridview-when-using-custom-data-sources.aspx there's a link in the comments(http://ketulpatel.wordpress.com/2008/06/06/custom-paging-in-spgridview-extending-spgridviewpager/) on how to use SPGridViewPager but it doesnt work when you have spgridview.AllowGrouping = true. But thats not really a requirement, its just something i would like to do, it looks better than the "1 2 3 4" Pager.

My main problem is that i havent found any reference about having Totals and Counts in SPGridView...just in EndUserSharePoint.com something about jQuery...

---

http://pontodepartilha.blogspot.com

Answer 3

Remember this spgridview derived from gridview, so the same control exist on gridview also exist on spgridview.

Try use footertemplate of gridview to make you counts and sum. 

http://aspalliance.com/782

Examples code:

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.webcontrols.spgridview.onrowcreated.aspx

---

André Lage Microsoft SharePoint and CRM Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/

Answer 4

Thank you André,

It seems Grouping enabled caused an error on postback, i thk its a known bug and that was slowing things...

in rowdatabound or from sql i was able to get totals and counts :)

tks

---

http://pontodepartilha.blogspot.com