How do you create a form that saves to a SQL table?

TheMSsForum.com: The Microsoft Software Forum

You could do this easily enough when using ASP, what about in WSS?, I need to
submit results to a data base.
Top

Re: How do you create a form that saves to a SQL table? by gougler

gougler
Thu Nov 18 14:44:02 CST 2004

The data entry forms in WSS can only save to lists that are created in
WSS. For external data sources WSS only provides read-only support
(view only). You can use InfoPath forms to write data to external
datasources and publish them to WSS.

Top

Re: How do you create a form that saves to a SQL table? by SpaceJunk

SpaceJunk
Thu Nov 18 15:07:08 CST 2004

I am trying to do it in InfoPath right now, and I can only figure out how to
get it to submit the data to the form library, not to a SQL Table.

Do you know of a good reference for using InfoPath to put data from a form
into a SQL table?

Seems like were are going backwards in easability here. I used to be able
to create a form in seconds that could put data into a SQL table. Now with
WSS, it is not so easy.

"gougler" wrote:

> The data entry forms in WSS can only save to lists that are created in
> WSS. For external data sources WSS only provides read-only support
> (view only). You can use InfoPath forms to write data to external
> datasources and publish them to WSS.
>
>
Top

Re: How do you create a form that saves to a SQL table? by gougler

gougler
Thu Nov 18 15:41:39 CST 2004

Sorry - I can't help you with this. I have spent some time messing
around with InfoPath but I really find it hard to acocmplish even
simple tasks and I guess will wait for the next realease. It may not be
the product itself but my limited experience with it. ASP.NET / ADO.NET
may still be the easiest way to create data entry web interfaces...

Top

Re: How do you create a form that saves to a SQL table? by daniel

daniel
Fri Nov 19 15:27:10 CST 2004

Here's a few URLs from my bookmarks on doing this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_ta/html/odc_infopath_submitting_forms.asp
-- includes an example on submitting to SQL
"Submitting to a database makes sense for this scenario because of the
interaction with the issue table. New issue records are created directly from
the form. In general, you should consider submitting to a database when there
is direct interaction with database tables, without the need to manipulate
the form data. "

With a web service:

http://msdn.microsoft.com/office/understanding/infopath/default.aspx?pull=/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_09.asp

http://msdn.microsoft.com/office/understanding/infopath/default.aspx?pull=/library/en-us/odc_ip2003_ta/html/office_infopath_using_datasets.asp

Daniel Larson
www.portalbuilder.org



"Space Junk" wrote:

> I am trying to do it in InfoPath right now, and I can only figure out how to
> get it to submit the data to the form library, not to a SQL Table.
>
> Do you know of a good reference for using InfoPath to put data from a form
> into a SQL table?
>
> Seems like were are going backwards in easability here. I used to be able
> to create a form in seconds that could put data into a SQL table. Now with
> WSS, it is not so easy.
>
> "gougler" wrote:
>
> > The data entry forms in WSS can only save to lists that are created in
> > WSS. For external data sources WSS only provides read-only support
> > (view only). You can use InfoPath forms to write data to external
> > datasources and publish them to WSS.
> >
> >
Top