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

Все ответы

• 26 мая 2009 г. 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/
  • Ответить
  • Цитировать

   
• 26 мая 2009 г. 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
  • Ответить
  • Цитировать

   
• 26 мая 2009 г. 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 26 мая 2009 г. 21:12
  •  
  • Ответить
  • Цитировать

   
• 3 июля 2009 г. 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 7 июля 2009 г. 13:26
  • Помечено в качестве ответаPedro Mateus 3 июля 2009 г. 17:12
  •  
  • Ответить
  • Цитировать