<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Web Services</title><link>https://www.infopathdev.com:443/forums/48.aspx</link><description> </description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Secondary Submit Data Connection to a webservice does not submit !</title><link>https://www.infopathdev.com:443/forums/thread/31073.aspx</link><pubDate>Thu, 31 Jul 2008 17:12:54 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:31073</guid><dc:creator>swetha</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/31073.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&amp;PostID=31073</wfw:commentRss><description>&lt;p&gt;&amp;nbsp;Hi,&lt;br /&gt;&lt;br /&gt;I am trying to submit to a SQL server database using a secondary data connection via a web service .&lt;br /&gt;&lt;br /&gt;When I hit submit I do get the &amp;quot;Form submitted successfully&amp;quot; dialogue but the data does not commit to the database.&lt;br /&gt;&lt;br /&gt;Can anyone please tell me how to fix this..&lt;br /&gt;&lt;br /&gt;The webmethod for the Submit looks like this , where &amp;quot;Services &amp;quot; is my database table.&lt;br /&gt;&lt;br /&gt;[WebMethod]&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; public void SetDataSet(DataSet1 Data)&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (Data.HasChanges())&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; sqlDataAdapter1.Update(Data.Services);&lt;br /&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;&lt;br /&gt;Thanks,&lt;br /&gt;&lt;br /&gt;Swetha&lt;/p&gt;</description></item></channel></rss>