System.Data.SqlClient.SQLConnection con=new System.Data.SqlClient.SQLConnection("server=local;database=EmpDB;user id=sa;password=sa");

System.Data.SqlClient.SQLCommand cmd=new System.Data.SqlClient.SQLCommand();

cmd.Connection=con;
cmd.CommandText="Delete from TableName";

con.Open();
cmd.ExecuteNonQuery();
con.Close();

foreach(Control cnt in this.Controls)
{

  if(typeof(cnt).ToString().ToLower().Contails("checkbox) )
 {
if(((CheckBox)cnt).Text.ToString().Equals("2"))
{
    ((CheckBox)cnt).Checked=true;
    break;
}
}
}

static int count = 0;  
  
protected void Button1_Click(object sender, EventArgs e) 
{ 
//if the variable had been declared here it would have a scope  
//for the Button1 Click function only. 
  count++; 
  int noofcount=count; 
}

protected void Button1_Click(object sender, EventArgs e) 
{ 
static int count=0; 
count++; 
int noofcount=count; 
}