dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check...

When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not...

I have been profiling my codes and my scripts trying to debug why I have lost lots of .50 cents every transaction, given I always use the decimal datatype when computing currency values. The business logic layer persists correct values and profiler shows result with its fractional part being passed to...

An SqlParameter with ParameterDirection.Output has default size of 1 , this can be tricky if you use command.Parameters.AddWithValue(parameter, value) method in .NET 2.0. It was caught on my unit test when I want to retrieve the value of an output parameter, the returnErrorMessage variable must contain...