Count Menu clicks and save Number of clicks in SqlServer database 2005

Question

3.00/5 (2 votes)

See more:

Hello Friends,
Have a good day all of you !!!!!

Count Menu clicks and save Number of clicks in SqlServer database 2005.
=========================================================

I have Created a WEB Application in Asp.net C#, SqlServer 2005.

In this Web Appl I have Menus Such as Home,About us, View Result, View Toppers, Contact us....etc links in menus.

When User clicks this links it must count and store in SqlServer 2005 database.

So, that I can Know how many users are viewing my web application.

Please help me brothers.

Thanks a lot

Posted 16-Oct-12 20:10pm

Ubaid ur Rahman IT

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)

Sushil Mate · Answer 1 · 2012-10-16T20:39:00

Brother you don't have to do like that.

you have Global.asax file in your web project.

C#

void Application_Start(object sender, EventArgs e)     
{
   // Code that runs on application startup.        
   Application["Visitors"] = 0;
}

void Application_End(object sender, EventArgs e) 
{
        //  Code that runs on application shutdown
}
void Application_Error(object sender, EventArgs e) 
{ 
      // Code that runs when an unhandled error occurs  
}
void Session_Start(object sender, EventArgs e) 
 {
      // Code that runs when a new session is started.
       Application.Lock();
       Application["Visitors"] = Convert.ToInt32(Application["Visitors"])+1;
       Application.UnLock();
}
void Session_End(object sender, EventArgs e) 
{}

Whenever session_start event occurs you need to increase your visitor value by one & you can insert that value in the database.
Hope it helps

MT_ · Answer 2 · 2012-10-16T20:54:00

If you want to find unique visitors to your web-site, follow what Sushil has suggested above.

If you need to find total pages visited or number of pages visited, the simplest thing to do is to go for Google analytics which is free. You need to host site so that it accessible to Google Analytics.

Else, if you want to develop your own method, I would suggest you create a base page class ederived from system.page and then derive all your pages from this your own base page class.

In this custom base class, you advance total page count and user page count and/or store in database against the user.

Hope that helps. If it does, mark the answer as solution and/or upvote.

Thanks
Milind

Count Menu clicks and save Number of clicks in SqlServer database 2005

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0