Code

Re: dropdownbox

cali_kid — Thu, 08 Jan 2009 17:20:31 GMT

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.

Re: dropdownbox

cali_kid — Wed, 17 Dec 2008 20:48:12 GMT

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.

Re: dropdownbox

rishibajaj — Wed, 17 Dec 2008 11:29:22 GMT

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

Re: dropdownbox

cali_kid — Wed, 17 Dec 2008 04:12:07 GMT

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

Re: dropdownbox

rishibajaj — Tue, 16 Dec 2008 20:03:50 GMT

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

Re: dropdownbox

cali_kid — Tue, 16 Dec 2008 19:40:01 GMT

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

Re: dropdownbox

rishibajaj — Mon, 01 Dec 2008 13:54:49 GMT

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();

XPathNavigator ordernameNode = GetOrderDS.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetItemResponse/tns:GetItemResult/tns:clsItem/tns:ItemName[../tns:ItemID='" + LitNameI.Value + "']", NamespaceManager);

Re: dropdownbox

Jimmy — Mon, 01 Dec 2008 01:35:16 GMT

Yes, this should work:

XPathNavigator source = DataSources["GetOrders"].CreateNavigator();

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.

Re: dropdownbox

rishibajaj — Mon, 01 Dec 2008 01:23:49 GMT

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

XPathNavigator source = DataSources["GetOrders"].CreateNavigator();

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

foreach (XPathNavigator selectnode in retablerows)

{

string ordername = selectnode.SelectSingleNode("ordername", NamespaceManager).Value;

}

Re: dropdownbox

Jimmy — Mon, 01 Dec 2008 00:10:37 GMT

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.

dropdownbox

rishibajaj — Sun, 30 Nov 2008 23:41:39 GMT

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