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;
}
