Data Connections

Re: sorting a drop down list populated from a data connection

discodave82 — Thu, 12 Feb 2009 09:07:43 GMT

My solution to the problem is here :-

http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/4f739cec-220e-4ab2-a6d9-13079e43844a

Re: sorting a drop down list populated from a data connection

ErnestoM — Tue, 03 Feb 2009 21:15:47 GMT

I can suggest trying qRules, since it contains a command that allows you to sort without code.

http://www.infopathdev.com/files/folders/dbxldownload/entry34534.aspx

If you want more information about qRules do let me know.

Re: sorting a drop down list populated from a data connection

Shiva — Mon, 02 Feb 2009 15:34:19 GMT

Hello,

Can you debug once and let us know what your error is? Where you are struck in that code?

Are you able to add your xml nodes to sortValues?

Do you want to just sort list or elements position by sorting order also? Can you give more details on your error?

Re: sorting a drop down list populated from a data connection

fromonesource — Mon, 02 Feb 2009 11:47:59 GMT

Anuma,

I have seen those before and have spent some time getting each to work. I was not successful with the first method and the second suggestion of using the url that generates xml will not work in my case because I cannot modify the data connections. Do you have any ideas on how to get this method to work successfully? I need to accomplish this in C# if the solution is a codded approach.

XPathNavigator navigator = this.MainDataSource.CreateNavigator();
XPathNodeIterator repeatingNodes = navigator.SelectChildren("XPath of your field", "Namespace of your form");
ArrayList sortValues = new ArrayList();
foreach(XMLNode repeatingNode in repeatingNodes)
{
sortValues.Add(repeatingNode.xml);
}
sortValues.Sort();

Re: sorting a drop down list populated from a data connection

Anuma — Mon, 02 Feb 2009 10:50:59 GMT

Hi,

Can you verify below Links.

http://www.infopathdev.com/forums/t/10102.aspx
http://blogs.msdn.com/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx

sorting a drop down list populated from a data connection

fromonesource — Sun, 01 Feb 2009 19:31:47 GMT

I have a drop down menu being populated from a data connection bound to a sharepoint list. I need to sort the data in alphabetical order. The form will be used through the browser so I cannot rely on sorting the view (browser ignores default view sort order).

I guess what I would want to do in this case is to pop each of these items off the data connection, put them into an array, do some sorting and then put them back into the drop down menu. Could I get some code pointers around getting the items from the data source into the array and then back into the drop down menu in sort order?

I am under a bit of a deadline and I have spent a good amount of time on this already. Any help would be greatly appreciated!