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

Alle Antworten

• Dienstag, 26. Mai 2009 17:33André Lage

   
  

  0

  Zum Abstimmen anmelden
  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/
  • Antworten
  • Zitieren

   
• Dienstag, 26. Mai 2009 20:22Pedro Mateus

   
  

  0

  Zum Abstimmen anmelden
  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
  • Antworten
  • Zitieren

   
• Dienstag, 26. Mai 2009 20:54André Lage

   
  

  0

  Zum Abstimmen anmelden
  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/

  • BearbeitetAndré Lage Dienstag, 26. Mai 2009 21:12
  •  
  • Antworten
  • Zitieren

   
• Freitag, 3. Juli 2009 17:09Pedro Mateus

   
  

  0

  Zum Abstimmen anmelden
  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

  • Tag als Antwort aufgehobenPedro Mateus Dienstag, 7. Juli 2009 13:26
  • Als Antwort markiertPedro Mateus Freitag, 3. Juli 2009 17:12
  •  
  • Antworten
  • Zitieren