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);
}