Loading

C# code for taking monthly report

shamshad c

now i am trying to make a website for online registration for this kindle help me with c# code for taking last moth or last year report from a gridview,i am using sql express as back end

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ram Sagar Mourya12y ago
I hope the registration table in the database has a column to store the date on which user is registered.If not add one column as RegistrationDate with datetime as datatype.

then you write a query to get the data based on the RegistrationDate.

for eg:
To get the user's list for the last year.
Select * from RegistrationTable where YEAR(RegistrationDate) = YEAR(GETDATE()) - 1

in the same way try to figure out how to get last months registered user's list