ASP.NET Database Caching

Question

How can I  cache results from my  sql server database? Imagine a scenario where a user frequently access the data from the web application on a regular basis,the volume of data can be huge or small ,depending on amount of period he wants to access data. How can I cache these results from database and save my user's precious time in accessing the same information?What are the different ways?