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

All Replies

• Tuesday, May 26, 2009 5:33 PMAndré Lage

   
  

  0

  Sign In to Vote
  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/
  • Reply
  • Quote

   
• Tuesday, May 26, 2009 8:22 PMPedro Mateus

   
  

  0

  Sign In to Vote
  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
  • Reply
  • Quote

   
• Tuesday, May 26, 2009 8:54 PMAndré Lage

   
  

  0

  Sign In to Vote
  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/

  • Edited byAndré Lage Tuesday, May 26, 2009 9:12 PM
  •  
  • Reply
  • Quote

   
• Friday, July 03, 2009 5:09 PMPedro Mateus

   
  

  0

  Sign In to Vote
  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

  • Unmarked As Answer byPedro Mateus Tuesday, July 07, 2009 1:26 PM
  • Marked As Answer byPedro Mateus Friday, July 03, 2009 5:12 PM
  •  
  • Reply
  • Quote