InfoPath Dev

I want to take the VALUE of a drop down down box (which is a list of users and the actual value is their domain username e.g. DOMAIN\username) pass it to a bit of code which searches Active directory and then outputs the users email address to a text box. I can do this for the logged on user no problem but the below code just does not work for the life of me, it is on the changed event of the drop down list so i know that the data is not read only. Any ideas?

what is this statement supposed to do 

userName2 = userName2(0, 6);

i think you should use

userName2 = userName2.Substring(0, 6);

its a mistake, i have put this line in now:

string userName2 = userName.SelectSingleNode("/my:myFields/my:Authoriser", NamespaceManager).Value.ToString().Remove(0, 6);

however still the same problem, output to a message box and the variable is being pulled ok but going wrong after that.

Thinking about assigning the code to a button to see if it works better that way!!!

why dont you debug your code and see what is breaking

Hi I have done this, its getting stuck on this line

searchresult result = searcher.findone();

the username is being passed ok e.g. an example username would be "tsy".

its says "the "tsy" search filter is invalid" I dont understand how this can be invalid, it is the correct active directory username

try this.  

    DirectorySearcher search = new DirectorySearcher();
    search.Filter = String.Format("(SAMAccountName={0})", userName);
    search.PropertiesToLoad.Add("cn");
    SearchResult result = search.FindOne();

Hi thanks for the reply. The updated code is below but still not working, getting frustrated now. I have tried putting in the line "LDAP:// "samaccount name +userName2 " (or along those lines)

this is not working either.

// Ensure that the constraint you are enforcing is compatible

// with the default value you set for this XML node.

// Get the user name of the current user.

DirectorySearcher search = new DirectorySearcher();

search.PropertiesToLoad.Add("cn");

// Make sure the user was found.

else

// Create a DirectoryEntry object to retrieve the collection

// of attributes (properties) for the user.

// Assign the specified properties to string variables.

// Create an XPathNavigator to walk the main data source

// of the form.

XmlNamespaceManager ns = this.NamespaceManager;

// Set the fields in the form.

// Clean up.

entry = new DirectoryEntry("LDAP://MyServer/DC=MyDomain,DC=net", "username", "password");

else

SearchResult sResultSet = Dsearch.FindOne();