InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumWed, 10 Jun 2026 22:23:39 GMT20http://forum.strataframe.net/FindPost4673.aspxI have a BO that is sorting on an int field (int in SQL Server). However the sorted results are as if the field was alpha-numeric. I.e. it sorts 1, 10, 11, 12, 2, ect. Am I missing a setting? The field is an Int32 in the BO.Tue, 21 Nov 2006 13:33:38 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4702.aspxI've read about the comparers. I'm sure I'll be using them at some point. And yeah, I won't soon forget this lesson...I've got the scares to remind me :DTue, 21 Nov 2006 13:33:38 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4691.aspxJust as a side note, you can get the behavior you want through a list...or any other type of object or collection for that matter.  You can create a comparer object that compares two values any way that you like.  In fact, the framework has a sorter for a ListView called the ListViewItemSorter.  This can be used as a column sorter on a ListView.Mon, 20 Nov 2006 20:55:11 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost4690.aspxAs I have mentioned before...I know that you won't have this problem again ;) and I think that you said something about ... "Yeah, pain teaches" :DMon, 20 Nov 2006 20:52:11 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost4689.aspxThe Sorted (of a listbox) property set to none...works great now...did I mention I was new to dotnet ;)Mon, 20 Nov 2006 17:51:40 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4688.aspxAh...I think the problem is that I'm using CopyData to fill a listbox and the listbox is sorting using alpha...the BO is sorting OK. I'll have to think of how to handle this.Mon, 20 Nov 2006 17:41:11 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost4676.aspxIt should sort in integer order if the field created is in fact integer in the CurrentDataTable.  All we do is set the sort in the DefaultView of the DataTable (CurrentView property of the BO).  Open up the debugger, add the MyBO.CurrentDataTable to the watch window, and verify that the field is coming back as Int32.Mon, 20 Nov 2006 16:16:17 GMTTrent L. Taylor