private void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) count(); } public void count() { int currentCount = 0; string sql = "SELECT COUNT FROM COUNTER WHERE COUNTERID=1"; SqlDataReader myFeed = SqlHelper.ExecuteReader(myConn, CommandType.Text, sql); while (myFeed.Read()) { currentCount = Convert.ToInt32(myFeed["count"]); LBLcounter.Text = currentCount.ToString(); currentCount++; } string sql2 = "UPDATE COUNTER SET COUNT="+currentCount+" WHERE COUNTERID=1"; SqlHelper.ExecuteNonQuery(myConn, CommandType.Text, sql2); }