Query a SharePoint List from InfoPath web form in code

Posted by dawsonweb on Stack Overflow See other posts from Stack Overflow or by dawsonweb
Published on 2010-03-29T13:08:32Z Indexed on 2010/05/27 12:11 UTC
Read the original article Hit count: 167

Filed under:

query

|

infopath

|

sharepoint-list

I'm writing an InfoPath web form, using C# code behind. The form is a holiday request, after the user inputs the start and end dates I want the code to query a bank-holiday sharepoint list and count occurrences between the dates.

I've added the sharepoint list as a second datasource however I'm now stuck. Any ideas?

© Stack Overflow or respective owner

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More

Related posts about infopath

INFOPATH 2007 Copy XPATH Option, How i can get the Copy Xpath option in INFOPATH 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I new for this Inopath, My quesion, InfoPath 2007 , I Can right click filed name i can get CopyXPATH, I Want CopyXPath function in INFOPATH 2003, HOW I Can get CopyXpath option Thanks >>> More
Saving a modified InfoPath form to its form library

as seen on Server Fault - Search for 'Server Fault'
Within our corporate SharePoint 2007 site, there is a particular form library that contains 10 separate files. 9 of these are either Excel, Word, or PowerPoint files and one of these is an InfoPath 2007 form that serves as a report. After noticing an error within this InfoPath form, I saved this… >>> More
Load InfoPath 2010 Forms & XSN Templates in .NET Web Applications

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Aspose.Form for .NET now provides full support for InfoPath 2010 controls. Now it is possible to load InfoPath 2010 forms and XSN Templates in .NET Web Applications. Following is the list of InfoPath 2010 controls that are fully supported. Text Box … >>> More
Populate InfoPath Combo Box

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to populate a drop down and found this page, which provides part of the solution: http://www.bizsupportonline.net/infopath2007/programmatically-fill-populate-drop-down-list-box-infopath-2007.htm I got this to work, but if players.xml was changed, the drop down list didn't reflect it… >>> More
Creating a new Active Directory account with an InfoPath form

as seen on Server Fault - Search for 'Server Fault'
I am setting up a business partner portal in our Sharepoint server. There will be an AD group with permissions limited to viewing and possibly contributing to the specific business partner site and employees of our business partners will have accounts created for them as needed. Now we would like… >>> More