private void b_ok_Click(object sender, EventArgs e) { MySqlConnection conn; conn = new MySqlConnection("Database=test;Data Source=localhost;User Id=user;Password=1234"); conn.Open(); string SQL_String = "INSERT INTO d_cabel_type (Name, Type, Voltage, Material, Climate) VALUES(@Name, @Type, @Voltage, @Material, @Climate)"; MySqlCommand comm = new MySqlCommand(SQL_String, conn); comm.Connection = conn; comm.Parameters.AddRange(new MySqlParameter[] { new MySqlParameter("Name", MySqlDbType.VarChar, 25, "Name"), new MySqlParameter("Type", MySqlDbType.VarChar, 25, "Type"), new MySqlParameter("Voltage", MySqlDbType.VarChar, 25, "Voltage"), new MySqlParameter("Material", MySqlDbType.VarChar, 25, "Material"), new MySqlParameter("Climate", MySqlDbType.VarChar, 25, "Climate")}); string type, material; if (rb_type_1.Checked) { type = "Круглые"; } else { type = "Секторные"; } if (rb_material_1.Checked) { material = "Медь"; } else { material = "Алюминий"; } comm.Parameters[0].Value = t_name.Text; comm.Parameters[1].Value = type; comm.Parameters[2].Value = t_voltage.Text; comm.Parameters[3].Value = material; comm.Parameters[4].Value = t_climate.Text; int rows = comm.ExecuteNonQuery(); //conn.Close(); MySqlCommand c = new MySqlCommand("SELECT ID FROM d_cabel_type WHERE (Name = '" + t_name.Text + "' AND Type = '" + type + "' AND Voltage = '" + t_voltage.Text + "' AND Material = '" + material + "' AND Climate = '" + t_climate.Text + "')", conn); MySqlDataReader dr; dr = c.ExecuteReader(); while (dr.Read()) { DataCabel.cabel_type_id = dr[0].ToString(); } conn.Close(); d_cabel_info d_info = new d_cabel_info(); d_info.Show(); this.Close(); }
private void b_open_Click(object sender, EventArgs e) { MySqlConnection conn; conn = new MySqlConnection("Database=test;Data Source=localhost;User Id=user;Password=1234"); conn.Open(); MySqlCommand c = new MySqlCommand("SELECT ID FROM d_cabel_type WHERE (Name = '" + cb_name.Text + "' AND Type = '" + cb_type.Text + "' AND Voltage = '" + cb_voltage.Text + "')", conn); MySqlDataReader dr; dr = c.ExecuteReader(); while (dr.Read()) { DataCabel.cabel_type_id = dr[0].ToString(); } conn.Close(); d_cabel_info d_info = new d_cabel_info(); d_info.Show(); }