need to calculate the total days in a month in asp.net

As Abrar said, the basic method to do this from C# is DateTime.DaysInMonth.

However, if you only want to use this to calculate daily salary, you could wrap it in a method as follows:

You can directly do it from database like this way


DECLARE @pDate datetime, @no_days INT
SET @pDate = CONVERT(DATETIME,'01/06/2014')-1
SELECT @no_days = CASE WHEN MONTH(@pDate) IN (1, 3, 5, 7, 8, 10, 12) THEN 31
WHEN MONTH(@pDate) IN (4, 6, 9, 11) THEN 30
ELSE CASE WHEN (YEAR(@pDate) % 4    = 0 AND YEAR(@pDate) % 100 != 0) OR (YEAR(@pDate) % 400  = 0)
 THEN 29
 ELSE 28
END
END
 
SELECT @no_days as [no_days]


SELECT  CAST (('2000'/CAST ( @no_days AS DECIMAL(18,2)))AS DECIMAL(18,2))

Hi

Use System.DateTime.DaysInMonth, from code sample:

const int July = 7;
const int Feb = 2;

// daysInJuly gets 31.
int daysInJuly = System.DateTime.DaysInMonth(2001, July);

// daysInFeb gets 28 because the year 1998 was not a leap year.
int daysInFeb = System.DateTime.DaysInMonth(1998, Feb);