private void Insertbtn_Click(object sender, EventArgs e) { string connStr = "server=localhost;user=root;database=birjha_truda;"; // создаём объект для подключения к БД MySqlConnection connection = new MySqlConnection(connStr); connection.Open(); string sql = "INSERT INTO `birjha_truda`.`companies`" + "(`id_Company`, `Company`, `Region`, `Kont_data`," + " `Prof_Napr`, `Type`, `Info`) VALUES " + "(NULL, '" + Company.Text + "','" + Region.Text + "','" + Kont_data.Text + "','" + Napr.Text + "','" + Type.Text + "','" + Info.Text + "');"; MySqlCommand command = new MySqlCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); Company.Clear(); Region.Clear(); Kont_data.Clear(); Napr.Clear(); Type.Clear(); Info.Clear(); }
public void SetNapr(Napr n) { what = n; }