Displaying Employee Monthly Data into gridview from Table

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

0

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:

status,transaction_date,time in,time out,hrs worked

i want current month data of the emp who's logged in ... Suggest a procedure which ill pass from grid view function

0

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

0