Results not sorted Correctly when System.Data.DataTable.Select(Filter, Sort) is used
If you are using Windows 2003 SP1 there is an issue in System.Data.dll in .NET Framework 1.1 SP1 which will cause the resulted data to be incorrectly sorted. This is a bug of .Net Framework 1.1.
DataSet1.Table1.Select("Filter1=1 AND Filter2=2 AND Filter3=3", "SortColumn1")
The result of the above statement wont be sorted according to the SortColumn1. But it will be sorted using the Column 1 of the dataset. But if you remove the AND operators used then the result will start to sorting again.
If you really want to sort the things while using AND operators, try making the required sorting column (SortColumn1) the first column in the datatable.
At the moment there is no download and install solution from Microsoft but they said to contact them to find out a solution.
If you like to know more on this you can visit the related Microsoft support center from the following link.
http://support.microsoft.com/Default.aspx?id=900468
Showing posts with label DataTable.Select Not Sorting. Show all posts
Showing posts with label DataTable.Select Not Sorting. Show all posts
Friday, November 24, 2006
Subscribe to:
Posts (Atom)
-
Normally in ASP.Net TreeView you can enable it to show checkboxes in its node levels. So if you need to do any actions when a node is checke...
-
Recently one of my computers had an issue with the Windows Explorer. It was crashing constantly when I try to click, right click or hover on...