How to hit counts in ASP.NET?

Question

1.00/5 (1 vote)

See more:

This is the code in classic asp:

ASP

set con=Server.CreateObject("ADODB.Connection")
con.Open strcon
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM category where news_allow=1",con,0,1 
		
do while not rs.eof
	news_visit=0
	set rst=Server.CreateObject("ADODB.Recordset")
	rst.Open "SELECT news_visit FROM news_list where news_ID="&rs("news_ID")&" and news_status=1",con,0,1 
				
	do while not rst.eof
        news_visit=rst("news_visit")+news_visit
	rst.MoveNext
        loop	
set rst=nothing

The page contain news category and under the category it display how many news are there and how many times hit this category news. I want this code in C#. If user click the news under the category then the news_visit counter is +1.

Please any one can help me how can I do this.

Thanks in advance

Posted 9-Jun-11 2:27am

rahul dev123

Updated 9-Jun-11 5:16am

Sandeep Mewara

v3

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)

suprcodr · Answer 1 · 2011-06-09T05:51:00

While the question you are asking is somewhat vague, I think I may be able to help.

When you want to store hits across your entire application in ASP.NET, you should use an application level variable. These work the same way as session variables except (you guessed it) they don't expire at the end of a session. They WILL however reset when the application is restarted/terminated.

If you do not care if the numbers reset upon an application restart, then use an application level variable. Attach an event handler to the click event of the linkbutton, button, or whatever button you choose to use that will increment the application variable by one. Here is a tutorial on application level variables: http://weblogs.asp.net/albertpascual/archive/2010/03/01/difference-between-asp-net-sessions-application-variables-and-cache-objects.aspx[^]

If you DO care if the numbers reset upon an application restart (or if your application is going to be running on multiple servers) then you should take the same approach as previously mentioned but instead of using application state to store your value, use a database system to push/pull the variables.

Hope this helps

-Moarcodeplz

Monjurul Habib · Answer 2 · 2011-06-09T06:07:00

Solution 2

Creating a Simple Hit Counter with ASP.NET 4.0 and C#
http://archive.devnewz.com/2004/0127.html[^]
http://forums.asp.net/t/1149362.aspx/1?to+create+a+hit+counter+in+asp+net[^]

Posted 9-Jun-11 6:07am

Monjurul Habib