Secondary Submit Data Connection to a webservice does not submit !

[swethabilla]

Hi,

I am trying to submit to a SQL server database using a secondary data
connection via a web service .

When I hit submit I do get the "Form submitted successfully" dialogue
but the data does not commit to the database.

Can anyone please tell me how to fix this..

The webmethod for the Submit looks like this , where "Services " is my
database table.

[WebMethod]
public void SetDataSet(DataSet1 Data)
{
if (Data.HasChanges())
{
sqlDataAdapter1.Update(Data.Services);

}
}

Thanks,

Swetha

 

[Paresh]

Hi,

I am trying to submit to a SQL server database using a secondary data
connection via a web service .

When I hit submit I do get the "Form submitted successfully" dialogue
but the data does not commit to the database.

Can anyone please tell me how to fix this..

The webmethod for the Submit looks like this , where "Services " is my
database table.

[WebMethod]
public void SetDataSet(DataSet1 Data)
{
if (Data.HasChanges())
{
sqlDataAdapter1.Update(Data.Services);

}
}

Thanks,

Swetha

Hi Swetha,

Please take a look at the following link:
http://blogs.msdn.com/infopath/arch...-web-services-in-infopath-forms-services.aspx

Hope this helps. Do let me know, in case you need any further info.

Thanks,
Paresh

 

[swethabilla]

Hi Paresh,

I have gone through the link. But the fact is I first created the
design and the nodes
in infopath (as opposed to creating the submit connection first and
then inserting the nodes)
Now I want to connect the fields in the infopath to the submit
connection.
Can you tell me how to get SUBMIT working on this.

Thanks,
Swetha.