Re: Integrating InfoPath03/WSS3/SQL05

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Luke,

Thank you for the reply. Maybe I'm missing the point or not explaining
myself properly. Yes, I can upload the form (XSN file) to a Form Library
and it will be available to everyone. When someone fills out the form the
data is submitted to the database. But then there's no way to reopen the
form with that data from within SharePoint. There is no list showing the
data in the database. What I need is to be able to fill out an InfoPath
form, submit it's content, and have a list of entries where I can select
one, open it, and see the whole form filled in with that data. This is
exactly the behavior I get if I save an InfoPath form's data as an XML file
into a Document Library. Only instead of saving a file, I want the data in
a database so I can run other queries and reports that I can't run on XML
files. I hope that makes sense. Is this possible?

John


"Luke Zhang [MSFT]" <lukezhan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:vPajn7kVHHA.2268@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi John,

Can you upload such a form in the Form Library? We can upload such a form
template in the form library. When user open in from sharepoint site, they
can fill data and submit to SQL server, can this work for your solution?

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.




.

Relevant Pages

  • RE: GridView RowEditing Requery question
    ... Gridview is always retrieved from database directly? ... the calling side always get the cached resultset. ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: GridView RowEditing Requery question
    ... Gridview is always retrieved from database directly? ... ** Implement local cache in your ASP.NET application(for the data access ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: query-based update failed
    ... Could you please clarify a bit more on what you mean by "checking each record in your recordset to see if it is in your database table at that time"? ... Look forward to your response. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.odbc)
  • Re: VS2008 DBE (GDR)
    ... target database, which already has data in some lookup tables. ... Microsoft Online Community Support ... nature are best handled working with a dedicated Microsoft Support Engineer ...
    (microsoft.public.vsnet.general)
  • Re: Multipule Postbacks
    ... upload you can store the uploaded file to a temp folder or database. ... Microsoft Online Support ... nature are best handled working with a dedicated Microsoft Support Engineer ...
    (microsoft.public.dotnet.framework.aspnet)