All pastes #443482 Raw Edit

Something

public text v1 · immutable
·published 2007-04-16 20:40 UTC
rendered paste body
		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);
		}