asp.net C# hit counter

Is there a folder in the same directory as the .aspx file itself which is named "content"? If so, have you created the file named "hitcounter_webform15.txt" within that directory? If yes, then are you receiving any errors (or exceptions)?

The guy here has developed a custom control for the same, just give it a thought:-
http://www.codeproject.com/Articles/5912/Easy-to-use-Hit-Counter

Here is another implementation:-
http://www.codeproject.com/Articles/2542/Page-Hit-Counter-using-ASP-NET-and-JScript-NET

Kaufmed,

Thank you for the quick reply.  Indeed, there is a "counter" folder and within it, there is a file namded "hitcounter_webform15.txt".  This counter seems to function in my local machine environment and in the test server, however, when I deploy this to the production server, I receive no error message, but the database is not updated when the page loads.

ANY help would be greatly appreciated.

Database? I thought you were writing to a file.

Kaufmed,

Please let me explain.  My requirements have changed.  In order to store historical information on website popularity (# of hits / quarter, etc.), I have been asked to write the number of hits to a SQL database table.  

My code for the *.aspx page is as follows:
----------------
<!--panel for page hit counter statistics starts -->            
<asp:Panel ID="pnl_statistics" runat="server" Visible="false">
<asp:Label ID="lblPageName" runat="server" Text="Contact_Us"></asp:Label>&nbsp;
<asp:Label ID="lblHits" runat="server" ></asp:Label>&nbsp;&nbsp;
<asp:Label ID="lblHitCounterDateDisplay" runat="server" Text="Label"></asp:Label>&nbsp;&nbsp;<asp:Label ID="lblHitCounterDate" runat="server" Text="Label"></asp:Label>
</asp:Panel>        
<!--panel for page hit counter statistics ends -->
---------------

My codebehind to support this is as follows:
--------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Configuration;
using System.Collections;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using System.Drawing.Imaging;
using System.Net.Mail;
using System.IO;

namespace xxxxxxxxxxxxxxxx

{

    public partial class Contact_Us : System.Web.UI.Page
    {
        string strConnStringHitCounterNew = ConfigurationSettings.AppSettings["HitCounterNew"];

        protected void Page_Load(object sender, EventArgs e)
        {
           
            //objects we will need to work with the db    
            SqlConnection conn;
            SqlCommand cmd;

            //pnl_warrants_search.Visible = true;


            lblHitCounterDateDisplay.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ");

            if (!Page.IsPostBack)
            {
                //connect to the db        
                conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["HitCounterNew"].ConnectionString);

                //the sql command to increment hits by 1        
                cmd = new SqlCommand("UPDATE HitCounterNew SET HitCounter = HitCounter+1, HitCounterDate = @HitCounterDate WHERE PageName=@PageName", conn);
                cmd.CommandType = CommandType.Text;
                //update where Name is 'about_us' which corresponds to this page        
                cmd.Parameters.AddWithValue("@PageName", "Contact_Us");
                cmd.Parameters.AddWithValue("HitCounterDate", lblHitCounterDateDisplay.Text);

                using (conn)
                {
                    //open the connection            
                    conn.Open();

                    //send the query  -- To Update Hit Counter
                    cmd.ExecuteNonQuery();

                    //Another command To Store Date
                    cmd = new SqlCommand("Insert Into HitCounterNew (PageName,HitCounter,HitCounterDate) Values(@PageName,@HitCounter,@HitCounterDate)", conn);
                    cmd.Parameters.AddWithValue("@PageName", lblPageName.Text);
                    cmd.Parameters.AddWithValue("@HitCounter", lblHits.Text);
                    cmd.Parameters.AddWithValue("@HitCounterDate", lblHitCounterDateDisplay.Text);
                    cmd.ExecuteNonQuery();

                }


            }

            //DISPLAY HITS IN OUR LABEL    
            //connect to the db    
            conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["HitCounterNew"].ConnectionString);

            //the sql command to select the row of hits corresponding to this page    
            cmd = new SqlCommand("SELECT * FROM HitCounterNew WHERE PageName=@PageName", conn);
            cmd.CommandType = CommandType.Text;

            //select where Name is 'about_us' which corresponds to this page    
            cmd.Parameters.AddWithValue("@PageName", "Contact_Us");
            cmd.Parameters.AddWithValue("@HitCounterDate", "Contact_Us");

            using (conn)
            {   //open the connection        
                conn.Open();
                //send the query and store the results in a sqldatareader        
                SqlDataReader rdr = cmd.ExecuteReader();
                if (rdr.Read())
                {
                    //set the text of our label to the current # of hits            
                    lblHits.Text = "Counter Pageviews: - " + rdr["HitCounter"].ToString();
                    lblHitCounterDate.Text = "HitCounter Date: - " + rdr["HitCounterDate"];
                }
            }

        }
         
 }
 }
 }
------------------

In my local machine and in our test server, this code functions as expected.  However, when I push this code to our production server, it hangs and does not write to the database (I'm monitoring the sql database table "HitCounterNew").  

I am at a loss to explain or fix the issue related to this code not functioning on the production server.

ANY HELP would be greatly appreciated.

darjimaulik,

Thank you for your suggestions. Indeed, I am attempting to  have a page counter that writes toa a SQL database but I'm having problems not duplicating records.  

ANY sample code that could help me with this would be greatly appreciated.