public void updateLawyer(updateuser uu)
 {
     cmd = new SqlCommand("UPDATE Employee  SET baro_no = @new_baro_no, name = @new_name, surname=@new_surname, address=@new_address, phone=@new_phone WHERE baro_no=@updating_baro_no;", con);
     cmd.Parameters.AddWithValue("@updating_baro_no", uu.updating_baro_no);
     cmd.Parameters.AddWithValue("@new_baro_no", uu.baro_no);
     cmd.Parameters.AddWithValue("@new_name", uu.name);
     cmd.Parameters.AddWithValue("@new_surname", uu.surname);
     cmd.Parameters.AddWithValue("@new_address", uu.address);
     cmd.Parameters.AddWithValue("@new_phone", uu.phone);
     con.Open();
     cmd.ExecuteNonQuery();
     con.Close();
 }
Exemplo n.º 2
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        updateuser uu = new updateuser();

        uu.updating_baro_no = Convert.ToInt32(TextBox6.Text);
        uu.baro_no          = Convert.ToInt32(TextBox1.Text);
        uu.name             = TextBox2.Text;
        uu.surname          = TextBox3.Text;
        uu.address          = TextBox4.Text;
        uu.phone            = TextBox5.Text;
        uu.updateLawyer();
        TextBox1.Text  = "";
        TextBox2.Text  = "";
        TextBox3.Text  = "";
        TextBox4.Text  = "";
        TextBox5.Text  = "";
        TextBox6.Text  = "";
        Label1.Visible = true;
    }