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

全部回复

• 2009年5月26日 17:33André Lage

   
  

  0

  登录进行投票
  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/
  • 回复
  • 引用

   
• 2009年5月26日 20:22Pedro Mateus

   
  

  0

  登录进行投票
  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
  • 回复
  • 引用

   
• 2009年5月26日 20:54André Lage

   
  

  0

  登录进行投票
  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/

  • 已编辑André Lage 2009年5月26日 21:12
  •  
  • 回复
  • 引用

   
• 2009年7月3日 17:09Pedro Mateus

   
  

  0

  登录进行投票
  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

  • 取消答案标记Pedro Mateus 2009年7月7日 13:26
  • 已标记为答案Pedro Mateus 2009年7月3日 17:12
  •  
  • 回复
  • 引用