C# code for taking monthly report

Question

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 gridviewi am using sql express as back end

Ram Sagar Mourya · Answer

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