Calculate period of time with .NET

Hi all,

We all are facing problem in calculating difference between date.

I have one good delicious, have a look at Calculate period of time with .NET.

Global.asax problem in Webservice...

hello all,

I came accrosse one situation where i need to execute code on Application Start, but due to some problem webservice was not executing code written in Global.asax file.

After googling i got good link as soluction, The missing part was code file

Have a look at delicious Problem with Global.asax file in VS 2005.

ANTS Profiler - .NET code and memory profiler

ANTS Profiler identifies performance bottlenecks in applications written in any of the languages available on the .NET Framework. To profile your application, use your application as normal within ANTS Profiler. During the performance profiling, ANTS Profiler records the frequency and time it takes for each line of code to be executed, as you are using your application. Detailed results will then reveal the slowest lines of code and methods, allowing you to quickly identify performance bottlenecks and optimize your .NET application accordingly.

Have a look at delicios.

Implementing the Singleton Pattern in C#

Hi

I found good article on Singlelton Pattern, what is singleton, how to implement etc ....

Have a look at delicios.

HTTP Response Codes

Hi all,

In the web world we are getting lots of HTTP error, i have delicios which has all the response codes with its description.

A Complete URL Rewriting Solution for ASP.NET 2.0

Hi All,

I found one interesting article, which is simply best for URL Rewriting.

I have delicious on URL Rewriting

Avoid dynamic query at some extend [SQL 2k]

select * from [northwind].[dbo].[orders]

This will probably returns 830 rows [thats default],

Now what if I want top 10 rows or to 20 rows may be more, I will create dynamic query like...

declare @statement varchar(100)
declare @iTop int
set @iTop=3
set @statement ='select top ' + convert(varchar(2),@iTop) +  ' * from [northwind].[dbo].[orders]'
EXEC (@statement)

We can do as follows which don't requrie creating dynamic query.

declare @iTop int
set @iTop=3
set rowcount @iTop
select * from [northwind].[dbo].[orders]

This will display top 3 records!!

Now set rowcount to 0 to get all the records

set rowcount 0