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

모든 응답

• 2009년 5월 26일 화요일 오후 5: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일 화요일 오후 8: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일 화요일 오후 8: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일 화요일 오후 9:12
  •  
  • 응답
  • 인용

   
• 2009년 7월 3일 금요일 오후 5: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일 화요일 오후 1:26
  • 답변으로 표시됨Pedro Mateus 2009년 7월 3일 금요일 오후 5:12
  •  
  • 응답
  • 인용