private void button5_Click(object sender, EventArgs e)
{
info Iinfo = new info();
Iinfo.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection cn = getConnection())
{
SqlCommand command = new SqlCommand(" UPDATE info SET [user_name] = @user_name, [surname] = @surname, [birthday] = @birthday, [phone] = @phone, [email] = @email WHERE [users_id]= @id", cn);
command.Parameters.Add("@user_name", SqlDbType.VarChar).Value = name_user.Text;
command.Parameters.Add("@surname", SqlDbType.VarChar).Value = surname_user.Text;
command.Parameters.Add("@birthday", SqlDbType.Date).Value = dateTimePicker1.Value;
command.Parameters.Add("@phone", SqlDbType.VarChar).Value = phone.Text;;
command.Parameters.Add("@email", SqlDbType.VarChar).Value = email.Text;
command.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id.get_idUser());
cn.Open();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Все данные успешно обновлены!!!");
this.Hide();
Iinfo.Show();
}
}
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}