Submitting data to SQL

[JuJu]

I can find a lot of information on how to build a form
from a SQL db, but none on how to submit data back to a
SQL db. Do I have to do this through a Web Service? Does
anyone have sample code I can see?

Thanks!

 

[Scott]

JuJu
On the Task Pane select Controls
Drag a Button on the the InfoPath Form
R-Click the button, select properties, in the Action drop-down select
Submit, apply changes.

Thats it!

 

[Guest]

I found that I didn't have the Submit to Database option
because I was using data from test tables I created and
did not create primary keys. Once I created primary keys
on the table the option to Submit to Database was
automatically enabled.

Thanks,
Heidi