<?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>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: after inserting data to database how to show sucess page?</title><link>https://www.infopathdev.com:443/forums/thread/34861.aspx</link><pubDate>Tue, 25 Nov 2008 07:42:56 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:34861</guid><dc:creator>Shiva</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/34861.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=34861</wfw:commentRss><description>&lt;p&gt;Hello,&lt;/p&gt;
&lt;p&gt;Do you want to refresh the page or update records you want to display in your page then after submitting data to database you have to call retrieve connection from database. It will give updated records data with newly added record also included in that result.&lt;/p&gt;
&lt;p&gt;Above rule will fire always when we try to submit the record to database. If the record submitting fails also it will give success message. For this we have to write the code to get the record is submitted successfully or not. &amp;nbsp;&lt;/p&gt;</description></item><item><title>Re: after inserting data to database how to show sucess page?</title><link>https://www.infopathdev.com:443/forums/thread/34848.aspx</link><pubDate>Tue, 25 Nov 2008 03:47:00 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:34848</guid><dc:creator>Anuma</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/34848.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=34848</wfw:commentRss><description>&lt;p class="MsoNormal" style="MARGIN:0in 0in 0pt;"&gt;&lt;font face="Times New Roman" size="3"&gt;Hi,&lt;/font&gt;&lt;/p&gt;&lt;font face="Times New Roman" size="3"&gt;&amp;nbsp;&lt;/font&gt; 
&lt;p class="MsoNormal" style="MARGIN:0in 0in 0pt;"&gt;&lt;font face="Times New Roman" size="3"&gt;Add Rule to the Button to show the Success message after submitting to Db.&lt;/font&gt;&lt;/p&gt;
&lt;ol style="MARGIN-TOP:0in;"&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l0 level1 lfo1;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Double click on the button and Select Rules button.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l0 level1 lfo1;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Click on “Add” button and Click on “Add Action” button.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l0 level1 lfo1;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Select “Show a Dialogue box Message” from Action dropdown.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l0 level1 lfo1;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Enter your message in “Message” field.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l0 level1 lfo1;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Click on ok.&lt;/font&gt;&lt;/li&gt;&lt;/ol&gt;&lt;font face="Times New Roman" size="3"&gt;&amp;nbsp;&lt;/font&gt; 
&lt;p class="MsoNormal" style="MARGIN:0in 0in 0pt;"&gt;&lt;font face="Times New Roman" size="3"&gt;And also add rule to clear the values in the form after showing the success message.&lt;/font&gt;&lt;/p&gt;
&lt;ol style="MARGIN-TOP:0in;"&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l1 level1 lfo2;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Double click on the button and Select Rules button.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l1 level1 lfo2;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Click on “Add” button and Click on “Add Action” button.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l1 level1 lfo2;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Select “Set a Field Value” from Action field.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l1 level1 lfo2;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Select field xpath from “Field” text box.&lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l1 level1 lfo2;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Leave “Value” as blank. &lt;/font&gt;&lt;/li&gt;
&lt;li class="MsoNormal" style="MARGIN:0in 0in 0pt;mso-list:l1 level1 lfo2;tab-stops:list .5in;"&gt;&lt;font face="Times New Roman" size="3"&gt;Click on ok.&lt;/font&gt;&lt;/li&gt;&lt;/ol&gt;</description></item><item><title>after inserting data to database how to show sucess page?</title><link>https://www.infopathdev.com:443/forums/thread/34814.aspx</link><pubDate>Mon, 24 Nov 2008 16:29:45 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:34814</guid><dc:creator>swapna_l9</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/34814.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=34814</wfw:commentRss><description>&lt;p&gt;after inserting data to database how to show sucess page or page refresh for submitting another record.&lt;/p&gt;</description></item></channel></rss>