Web Serviceshttps://www.infopathdev.com:443/forums/48.aspx enCommunityServer 2007 SP3 (Build: 31118.962)Re: Return 2000 rows from SQL2005 through WebServicehttps://www.infopathdev.com:443/forums/thread/22758.aspxWed, 29 Aug 2007 18:21:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:22758cocodog1230https://www.infopathdev.com:443/forums/thread/22758.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=22758<p>Qucik FYI,</p><p>&nbsp;</p><p>&nbsp;It&#39;s browser enabled form ( and it&#39;s in 2007 infopath).<br /><br />&nbsp;</p>Return 2000 rows from SQL2005 through WebServicehttps://www.infopathdev.com:443/forums/thread/22756.aspxWed, 29 Aug 2007 18:20:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:22756cocodog1230https://www.infopathdev.com:443/forums/thread/22756.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=22756<p>Hi Guys,</p><p>I&#39;ve a customer who wants to display 2000+ rows into a drop down of InfoPath form at once.&nbsp; However, the form fails to do that so is there a way to return that many rows at once via WebService and just filter them in code behind.</p><p>I&#39;m looking for an explanation where we will hit the ceiling as far how much data can be returned from&nbsp; SQL2005 in one call through web service?&nbsp; Any suggestion or help is greatly appreciated.</p><p>&nbsp;</p><p>Thanks.&nbsp;</p>