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

Tutte le risposte

• martedì 26 maggio 2009 17.33André Lage

   
  

  0

  Registrati per votare
  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/
  • Risposta
  • Citazione

   
• martedì 26 maggio 2009 20.22Pedro Mateus

   
  

  0

  Registrati per votare
  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
  • Risposta
  • Citazione

   
• martedì 26 maggio 2009 20.54André Lage

   
  

  0

  Registrati per votare
  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/

  • ModificatoAndré Lage martedì 26 maggio 2009 21.12
  •  
  • Risposta
  • Citazione

   
• venerdì 3 luglio 2009 17.09Pedro Mateus

   
  

  0

  Registrati per votare
  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

  • Contrassegno come risposta annullatoPedro Mateus martedì 7 luglio 2009 13.26
  • Contrassegnato come rispostaPedro Mateus venerdì 3 luglio 2009 17.12
  •  
  • Risposta
  • Citazione