Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / January 2007

Tip: Looking for answers? Try searching our database.

Accessing InfoPath data held in Sharepoint

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
darrylgould@lycos.co.uk - 24 Jan 2007 15:13 GMT
Hello

Is it possible to query / access data held in a SharePoint library from
outside of SharePoint?

At present we have an InfoPath form which submits to a SharePoint
library.  Is it possible to query the contents of all the forms without
going into SharePoint?

I ask the question because we would ideally like to have all the data
on the forms transferred to a SQL table.

Thanks
Darryl
S.Y.M. Wong-A-Ton - 25 Jan 2007 05:15 GMT
You can use the WebClient class in .NET to retrieve a form from a library as
a binary stream. From there you can do whatever you like with the stream.

Another option is to directly connect to the SharePoint database containing
the forms in SQL Server. Note: This is *not recommended* by Microsoft. You'd
have to do some investigation which database and/or tables you'd need to
access to retrieve the forms, but after you have that it's the same thing as
with the WebClient class, retrieve the BLOB for the form and then use it to
you likings.
---
S.Y.M. Wong-A-Ton

> Hello
>
[quoted text clipped - 10 lines]
> Thanks
> Darryl
darrylgould@lycos.co.uk - 25 Jan 2007 05:27 GMT
Many thanks

On Jan 25, 5:15 am, S.Y.M. Wong-A-Ton
<SYMWongA...@discussions.microsoft.com> wrote:
> You can use the WebClient class in .NET to retrieve a form from a library as
> a binary stream. From there you can do whatever you like with the stream.
[quoted text clipped - 23 lines]
> > Thanks
> > Darryl- Hide quoted text -- Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.