Displaying Employee Monthly Data into gridview from Table

Question

Hii I have a table named tblSchedule from which i want to extract a particular employee's timeintimeoutstatus....etc of the current month into a gridview. But the data should be of the employee who has logged in and of the current month(i.e from 1 to 30) and the gridview should have tabs to choose between next and previous month... So please can anyone provide me solution for this..Thanks in advance

Shakti Singh Dulawat · Answer

Yes passing stored procedure will work Just filter those based on employee I'd and transaction date

Viraj Kawthankar · Answer

Could You please tell me in detail... Passing a stored procedure can help ? I just need a stored procedure where i can create a session of Employeeid=@Employeeid My columns are: statustransaction_datetime intime outhrs worked i want current month data of the emp who's logged in ... Suggest a procedure which ill pass from grid view function

Shakti Singh Dulawat · Answer

Case A: If you are looking for particular than you can filter this table with based on employee ID and month Case B: If you are looking for all employee than you can filter it based on month ID Just create a function pass month id and employee ID and it will return you dataset that you can use to bind grid