How to make day by day filtering in mvc?

Question

I have one database that include these fields. ( Id ItemName ItemCategory BuyingDate Price ). I want to make filtering of BuyingDate to day by day. For example: There are so many rows with BuyingDate in database. I want to filter how many items are bought on the date(01/01/2001) (02/01/2001) and so on... Kindly give me advice how to implement if you have any idea. Thanks a lot for viewing my question.

Asp.Net Hein · Answer

Thanks for your reply. There are so many dates and if I need to implement day by day I need to write one query for one day? Any other improvements to make???

Vinay Singh · Answer

Hi use the below query select * from Item_Table_Master whereBuyingDate between '01/01/2001' and '02/01/2001'; Above query will return data between given two dates. Now get data for custom dates select * from Item_Table_Master where BuyingDate in('01/01/2001' '02/01/2001''04/01/2001');

Asp.Net Hein · Answer

Thanks for your reply. But actually I want to retrieve from database day by day. Do not prefer to choose date from user side.

Karthik Elumalai · Answer

Hi Hein My idea for this situation will be like we can split the Buying date into three separate dropdowns such as YearMonth and day and do the necessary thing according the selected item by user. Kindly refer the below link for more details: http://www.aspsnippets.com/Articles/Select-Day-Month-and-Year-Date-from-DropDownList-in-ASPNet.aspx hope this will give you some ideakindly let me know your thoughts thanks karthik