Skip to main content


Showing posts from November, 2006

Google Search

Custom Search

Live Search

Yahoo Search

Search the web Search this site
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.
Disabling the Shutdown Event Tracker in Windows 2003

If you try to Shutdown or Restart a computer running Windows 2003 OS you always have to give a reason for the shutdown or restart. This is because Shutdown Even Tracker is enabled. This will be great if it is a server, but this may be annoying if this is a normal PC. If anyone likes to stop this below I am discussing how to accomplish it.

1. In the Run Window (Start -> Run) type GPEdit.MSC and press enter.
2. Expand the Computer Configuration then Administrative Templates and then select System.
3. Double click on Display Shutdown Event Tracker to get the properties of it and select Disabled and click ok.

After these steps you will be able to shutdown the system as normal.

Sometimes your group policy settings may not apply immediately due to various reasons. To force apply the settings open the command window (Type Cmd in the run window) and type GPUpdate /force
This will force the changes made and any errors will be logged to the syst…
Registering Crystal Reports

Are you getting an exception
"Internal Exception: Cannot find KeycodeV2.dll or invalid keycode."
when you try to open a report done by Crystal reports?

Errors relating to KeycodeV2.dll can occur in VS.Net because of one of the following issues.
1. KeycodeV2.dll file is not accessible,
2. Does not have access to the registry keys which relate to KeycodeV2.dll,
3. Does not recognize the product Keycode stored in the registry.

Here I will address the last one, because most of the people doesn't know how to correctly register Crystal.

As the first step you have to add the licensing merge module which is Crystal_regwiz2003.msm (if you are using VS.Net 2002 the file will be RegWiz.msm) to your setup project.Then get to the properties window of the Merge Module.Expand the Merge Module Properties section in the Properties window and you will see a property called License Key.Enter the License key of your Crystal reports there.If any one is wondering what the L…