private void button2_Click(object sender, EventArgs e)
{
this.Hide();
ProviderCorrect pcf = new ProviderCorrect();
pcf.Show();
}
private void btn_delete_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(@"Data Source=NOUT;Initial Catalog=Phapm;Integrated Security=True");
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
sqlCommand.CommandText = "DELETE FROM PROVIDERS WHERE Name = '" + comboBox1.Text + "'";
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
MessageBox.Show("User '" + comboBox1.Text + "' is deleted!", "Info");
this.Hide();
ProviderCorrect pcf = new ProviderCorrect();
pcf.Show();
}
private void button2_Click(object sender, EventArgs e)
{
SqlCommand cmd;
SqlConnection con;
con = new SqlConnection(@"Data Source=NOUT;Initial Catalog=Phapm;Integrated Security=True");
con.Open();
cmd = new SqlCommand("INSERT INTO PROVIDERS (NAME, PHONE) VALUES (@name, @phone)", con);
cmd.Parameters.AddWithValue("@name", textBox1.Text);
cmd.Parameters.AddWithValue("@phone", textBox2.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("User '" + textBox1.Text + "' with phone nomber '" + textBox2.Text + "' is added!", "Info");
this.Hide();
ProviderCorrect pcf = new ProviderCorrect();
pcf.Show();
}
private void btn_AddProv_Click(object sender, EventArgs e)
{
ProviderCorrect prAdd = new ProviderCorrect();
prAdd.Show();
}