Code

Re: DataAdapters syntax

Hilary Stoupa — Fri, 18 Jul 2008 23:11:52 GMT

Okay, using VB.NET and IP2007:

' Get the e-mail submit data connection configured for the form.
Dim mySubmit As EmailSubmitConnection = DirectCast(Me.DataConnections("Main submit"), EmailSubmitConnection)
' Set To property to literal string value.
mySubmit.To.SetStringValue("someone@example.com")
' Submit form.
mySubmit.Execute()

This code came from here, (with a minor typo fix) and it compiles and runs. However -- several things of note. "Main submit" needs to be replaced with the name of your connection and there is no error handling. When the "pre-email" pop-up comes up in InfoPath, if I cancel sending the email, I'll get an error. The EmailSubmitConnection members are here and I do see Introduction, so you should be able to place a field there...

Hopefully this will get you started -- if you need help getting the value of a form field, look into XPathNavigator (or search here) and let me know if you get stuck, okay?

Re: DataAdapters syntax

Michael Vasquez — Fri, 18 Jul 2008 22:13:31 GMT

IP 2007

Mike

Re: DataAdapters syntax

Hilary Stoupa — Fri, 18 Jul 2008 20:46:02 GMT

I'm sorry, I shouldn't have abreviated. Are you using InfoPath 2003 or InfoPath 2007?

Re: DataAdapters syntax

Michael Vasquez — Fri, 18 Jul 2008 20:40:15 GMT

Basically, what I am doing is to submit the form, not using code, to a SharePoint List, which I am doing now with success. What I need to do is to email a confirmation email to a person requesting SharePoint training. I can do that using the current data connection. The problem is that the "To" field in the data connection sometimes uses the person's email address as firstname.lastname@company.com and somtimes the person's email address is firstname.mi.lastname@company.com. Big company and there are many instances that a person might have the same first and last name. Also, in the body of the field, I cannot insert any variables. The body has to be all text. Well, I need to add the date of the SharePoint Training Class. I have done that in the subject, but would want to add it in the body.

When you way "What version of IP are you using?", what is that?

I am doing all this in VB.net and all the samples out there do not work. They are either in JSript or C#.

Mike

Re: DataAdapters syntax

Hilary Stoupa — Fri, 18 Jul 2008 19:24:01 GMT

Hi--

Is there a reason you've set up a data connection to submit via email if you wish to submit using code? I'm just wondering -- did you have changes you wanted to make outside of the capabilities of the built-in email submit? If so, what are they? What version of IP are you using?

Re: DataAdapters syntax

Michael Vasquez — Fri, 18 Jul 2008 16:51:49 GMT

Still does not work. and Microsoft's samples are lame. For example from their page.

Visual Basic(Usage)
Dim instance as EmailAdapter
Dim value as String

value = instance.Subject
instance.Subject = value

Strange looking.

Other sample I found as an example: Dim oEmail As EmailAdapter = DirectCast(xDoc.DataAdapters("Email Submit"), EmailAdapter) and got "Object reference not set to an instance of an object error"

I am just trying to send an email using code. Can it be that difficult in VB? I have been working on this for three days. This is frustrating. There are no good samples. All the samples I have seen do not work are are incomplete. People have a tendency to give samples and they assume you are an expert in the code, so many of the samples don't make sense. Or when I try to use them, it seems incomplete.

Thanks for your help anyway.

Mike

Re: DataAdapters syntax

chandrakanth — Fri, 18 Jul 2008 12:36:40 GMT

<p>

Please perform the "Type Casting" on (xDoc.DataAdapters("Email Submit")) then your problem will get solved.I can help you by writing the code only but sorry i dont have better knowledge on VB.net code. But i can give clear idea on what it is in C#.

EmailAdapter oEmail = (EmailAdapter)xDoc.DataAdapters("Email Submit");

</p>

DataAdapters syntax

Michael Vasquez — Thu, 17 Jul 2008 17:23:45 GMT

Need help in using the the XDocument.DataAdapters using VB.net

Tried the following but keep getting errors.

Dim oEmail = XDocument

Dim xDoc = XDocument

oEmail = xDoc.DataAdapters("Email Submit")

The error I get is "Object reference not set to an instance of an object."

I do have a data connection called Email Submit.

Trying to email my form using code. Samples would help

Mike