InfoPath Dev

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!

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

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

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?

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.

My solution to the problem is here :-

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