InfoPath Dev

Hi, I have a form with a data connection to an sql database and I have the form is published to a SharePoint website. When I fill out the form from Sharepoint then submit it, it inserts into the sql database and then I send an email with the attached form. Then I save the form on Sharepoint.   So far everything is ...

Hi Patrick, When you say "Submit dialog" do you mean 'Rules for Submitting Forms"?  If so, I initially tried to add the message to the dialog box as the first rule, and that worked fine, but the message I want to display was way too large for the dialog box and thats what opened up this can of worms.  Can the ...

I had tried that code already, it compiles and executes without error and even the 'From submitted successfully" message displays,  except that it does not update the database.  I guess this is not possible to update the sql database using managed code using Microsoft.Office.InfoPath namespace classes and ...

Thanks Patkick, This seemingly trivial change to my form has turned into quite an ordeal.  I wrote this message on a previous post in the NewBee forum. "I have a form with 2 data connections, email and sql database. On submitting the form using the submit button on the toolbar it works just fine.  I use 'custom action ...

I have tried everything thus far. My main connection was created with the Data Connection Wizard if that makes a difference.  Also I am using infopath 2007.  All 3 examples below result in an error message when the form is run in debug.  The message is "InvalidCastException was unhandled by user code".  ...

I add the code as you suggest, but when I step through in debug, the fc.Execute() is never executed. I get a system error message "Infopath cannot submit the form. The OnSubmitRequest event handler returned a value indicating that the submit failed." my code is this; try{ FileSubmitConnection fc = ...

Thanks Qazi, But what is the correct code to use to submit my main connection,  up to this point I have not been successful except submitting the email connection. Thanks

I have a form with 2 data connections, email and sql database. On submitting the form using the submit button on the toolbar it works just fine.  I use 'custom action rules' in the submit options.  Also a pop up message is displayed (using C# managed code that is triggered when one of the required fields on the ...