how to count total days attendance in particular month for counting the salary in c#.net

Question

1 > how to count total days attendance in particular month for counting the salary in c#.net

2 > and also the how to bind datagridview at runtime in c#.net in microsoft visual studio 2010

HELP ME ANYONE

Senthilkumar · Answer

Hi Nilesh Try this... SELECT EmployeeID EmployeeName datepart(monthattendanceDate) As [Month]datepart(yearattendanceDate) As [Year]COUNT(*) AS [TotalWorkDays] FROM Attendance WHERE datepart(monthattendanceDate) = 4 AND datepart(yearattendanceDate) = 2012 GROUP BY EmployeeIDEmployeeNameattendanceDate