向数据库中更新数据代码.txt

学习积累的代码段

private void updata()//更新数据函数
    {
        SqlConnection con2 = db.creatcon();
        con2.Open();
        SqlCommand cmd = new SqlCommand("update  contract  set  tcid=@tcid,tpid=@tpid,tbegintime=@tbegintime,tendtime=@tendtime,ttotamoney=@ttotamoney,treadymoney=@treadymoney,tstate=@tstate,tcontent=@tcontent where  [tid]=@tid", con2);
    cmd.Connection = (SqlConnection)con2;
     

      cmd.Parameters.Add("@tid", SqlDbType.VarChar);
       cmd.Parameters.Add("@tcid", SqlDbType.VarChar);
       cmd.Parameters.Add("@tpid", SqlDbType.VarChar);
       cmd.Parameters.Add("@tbegintime", SqlDbType.DateTime);
       cmd.Parameters.Add("@tendtime", SqlDbType.DateTime);
       cmd.Parameters.Add("@ttotamoney", SqlDbType.Money);
       cmd.Parameters.Add("@treadymoney", SqlDbType.Money);
       cmd.Parameters.Add("@tstate", SqlDbType.Int);
       cmd.Parameters.Add("@tcontent", SqlDbType.VarChar);

    cmd.Parameters["@tid"].Value = this.Label1.Text.ToString();
       cmd.Parameters["@tcid"].Value = this.Label2.Text;
       cmd.Parameters["@tpid"].Value = this.DropDownList1.SelectedItem.Value;
       cmd.Parameters["@tbegintime"].Value = this.txtbegintime.Text;
       cmd.Parameters["@tendtime"].Value = this.txtendtime.Text;
       cmd.Parameters["@ttotamoney"].Value = this.txttotalmoney.Text;
       cmd.Parameters["@treadymoney"].Value = this.txtgetmoney.Text;
       cmd.Parameters["@tstate"].Value = this.DropDownList2.SelectedItem.Value;
       cmd.Parameters["@tcontent"].Value = this.txttcount.Text;
       cmd.ExecuteNonQuery();
         con2.Close();//关闭连接
         Response.Write("<script language='javascript'>alert('更新成功！')</script>");