infopath -- how to save data in database

[crish]

Hi...

Nice discussions on Infopath.. I found this forum/discussion more promising
for my present issues relating to infopath..

Scenario:
I ve the following controls in my infopath form - 1 dropdownlist
(values-d1,d2,d3), 1 textbox and 1 button (submit). I want to save value in
textbox in a tablerow of referred dropdown list. eg: value 23 to be saved in
d3 row of salesorder table in Adventureworks database.

Please go through the following issues..
1. Neither dropdownlist nor textbox is accessible in codebehind (C#).
2. dataadapter update is throwing errors that there is no proper referance
to store the data.
3. how to configure the submit button as to a definite table in database to
store the data.

Thanks in advance

 

[sema]

http://www.ggktech.com Kalyan G Reddy:

Also read this link
http://www.infopathdev.com/blogs/greg/archive/2004/07/27/Submit-to-a-SQL-Database.aspx