从数据库中删除数据代码.txt

学习积累的代码段

 private void delatecount()
    {

        SqlConnection con3 = db.creatcon();
        con3.Open();
        SqlCommand cmd3 = new SqlCommand(" delete contract  where tid=@tid",con3);
        cmd3.Parameters.Add("@tid",SqlDbType.VarChar);
        cmd3.Parameters["@tid"].Value = this.Label1.Text;
        cmd3.ExecuteNonQuery();
        con3.Close();
        Response.Write("<script language='javascript'>alert('数据删除成功！')</script>");
        Response.Redirect("updatacount.aspx");