SHOW COUNTER ON WEBSITE

STEP1
create a table Counter(CounterID bigint primary key identity,CounterName bigint,Updatedon datetime)
and insert a value
insert into Counter values(0,1);

STEP2
now create a procedure as

CREATE proc Counter_acteon
as
Declare @counter bigint
set @counter=(select top(1) CounterNumber from counter order by updatedon desc)
set @counter=@counter+1
insert Counter (counternumber) values (@counter)
SELECT RIGHT(replicate('0',7)+convert(varchar,@counter),8) as counter

STEP3

and open website where you want to add a counter
add a label control as

<asp:Label ID="lbl_counter" runat="server" ForeColor="White" 
                                    BackColor="Black" Font-Bold="True" Font-Size="Large" BorderStyle="Ridge"></asp:Label>

STEP4
write code on page load

public partial class _Default : System.Web.UI.Page
{

    cscounter csd = new cscounter();
    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt =csd.setcounter();
        lbl_counter.Text = dt.Rows[0][0].ToString();
    }
}

STEP5
then add a Class File and code following
public class cscounter
{
    public cscounter()
    {
    
    }

    private int _counter;


public int Counter
{
  get { return _counter; }
  set { _counter = value; }
}

public DataTable  setcounter()
{
    SqlConnection con = new SqlConnection("Data Source=SERVER2008R2\\ONLINE24X7; User ID=sa; Password=stream@1234; Initial Catalog=BSAWEBSITE;");
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "sp_select";
    cmd.CommandType = CommandType.StoredProcedure;

    DataTable dt = new DataTable();
    cmd.Connection = con;
    con.Open();
    SqlDataAdapter datadp = new SqlDataAdapter(cmd);
    datadp.Fill(dt);
  
    return dt;
}
}