InfoPath Dev

I have a dropdownlist box in infopath form. Drop down gets filled from database's order table. sample values are

 order name               orderid 

application kit           1

rellocationform          2

 when i change value of dropdown box then how can i get text of dropdown box programatically through c#. for example if i select rellocationform in drop down then how can i get text value (rellocationform) in a variable using c#

Thanks

There is no way to directly interact with InfoPath forms, so the only way to accomplish this is to get the current value of the field bound to the dropdown box, and then find the corresponding order name in the secondary data source that is being used to populate the form.

thanks i was able to do it but i had to introduce for each loop. is there any way i can avoid for loop and still achive the results. here is my code where i will like to avoid for loop

XPathNodeIterator retablerows = source.Select("/dfs:myFields/dfs:dataFields/tns:GetOrdersResponse/tns:GetOrdersResult/NewDataSet/Table[orderid='" + e.NewValue.Trim() + "']", NamespaceManager);

Yes, this should work:

XPathNavigator ordernameNode = source.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetOrdersResponse/tns:GetOrdersResult/NewDataSet/Table/ordername[../orderid='" + e.NewValue.Trim() + "']", NamespaceManager);

string ordername = ordernameNode.Value;

The parts I've changed are in bold.

Jimmy,

 thanks very much. this is what i did in case someone else runs into same problem, here is the solution :-

XPathNavigator GetOrderDS = DataSources["GetItem"].CreateNavigator();

Will this solution work in a form that is render via MOSS Form Services?

yes i did on that browser enabled form if that's what you mean?

Can you provide the steps necessary to implement this in a browser enabled form? New to InfoPath, and need some guidance.

I have to understand that what you are trying to do.

 What I am doing here is I have repeating table that has several rows in it. and then I have a dropdown box outside the repeating table. I am trying to get the row from repeating table to match the value selected in dropdown box.

 thanks

I'm not using a repeating table, I have a secondary data connection that pulls in list items from a list in SharePoint. This connection populates a drop down control. There's about 2,000 records in the list, and when I render the form via the browser, the sort that is based off of the view does not work through InfoPath form services. I've read several bloggs about using a preserve code block, but that solution is not supported in a browser enabled form. This needs to be sorted alphabetically.

Found the answer.

 http://www.infopathdev.com/forums/t/10102.aspx

This works without having to introduce code into the form. One of the requirements from this client is to create forms, and hand them off to someone who is not  a programmer.

Thanks for the posts though.