Most Viewed Articles in ASP

Question

4.00/5 (1 vote)

See more:

Hi Guys!
I am in developing a new articles website for someone in ASP using C# but there is a problem, that i want to implement the (Five most Viewed Articles) sometimes called (Five Most Popular Articles) How i can???
the code may in LINQ if not then in Straight forward Querying with SQL Server 2008 R2
~~pleaaaaaaaaaaaaaaaaase~~ help me

Posted 5-Sep-12 17:30pm

khaksar weqar

Updated 5-Sep-12 17:45pm

_Amy

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Monjurul Habib · Answer 1 · 2012-09-05T18:33:00

Try the following in LINQ:

C#

var list = (from article in ArticleTable
           where <apply your condition>
           orderby article.LastViewedTime
           select article ).Take(5);

Navigate the following links for further details on LINQ:
101 LINQ Samples
LINQ to SQL - Select Top N Rows
TOP/LIMIT Support for LINQ

Ashraff Ali Wahab · Answer 2 · 2012-09-05T18:08:00

Solution 1

SQL

SELECT TOP 5 ArticleTitle, ArticleInfo
FROM ArticleTable
ORDER BY TimesViewed DESC

Lets say you have ArticleTable and TimesViewed Column keeps track of how many times article has been viewed.The TOP Keyword in SQL will be able to fetch the record based on the count you supply,in your case it is 5.

Posted 5-Sep-12 18:08pm

Ashraff Ali Wahab

Comments

khaksar weqar 6-Sep-12 8:05am

But i havnt TimesViewed Column, if i create then how i can keep the track of times viewed of article, can u tell me the code?