косяк с прогой

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using MySql.Data.MySqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
 
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
 
        MySqlConnection myConnection = new MySqlConnection();
        public Form1()
        {
            InitializeComponent();
            
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
           
            try
            {
                string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
                MySqlConnection myConnection = new MySqlConnection(Connect);
                myConnection.Open();
                MessageBox.Show("Подключение прошло успешно");
 
                string sel = "select * from firma";
                MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
                MySqlDataAdapter adapter = new MySqlDataAdapter();
                adapter.SelectCommand = mc2;
 
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
 
                dataGridView1.DataSource = table;
                //------------------------------------------------------------------//
                string sel2 = "select * from rezume";
                MySqlCommand mc = new MySqlCommand(sel2, myConnection);
 
 
                MySqlDataAdapter adapter1 = new MySqlDataAdapter();
                adapter.SelectCommand = mc;
 
                DataTable table1 = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table1);
 
                dataGridView2.DataSource = table1;
                
                //------------------------------------------------------------------//
                string sel3 = "select * from sity";
                MySqlCommand mc3 = new MySqlCommand(sel3, myConnection);
 
 
                MySqlDataAdapter adapter2 = new MySqlDataAdapter();
                adapter.SelectCommand = mc3;
 
                DataTable table2 = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table2);
 
                dataGridView3.DataSource = table2;
                //------------------------------------------------------------------//
                string sel5 = "select * from vacans";
                MySqlCommand mc5 = new MySqlCommand(sel5, myConnection);
 
 
                MySqlDataAdapter adapter4 = new MySqlDataAdapter();
                adapter.SelectCommand = mc5;
 
                DataTable table4 = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table4);
 
                dataGridView5.DataSource = table4; 
                //------------------------------------------------------------------//
                string sel4 = "select * from special";
                MySqlCommand mc4 = new MySqlCommand(sel4, myConnection);
 
 
                MySqlDataAdapter adapter3 = new MySqlDataAdapter();
                adapter.SelectCommand = mc4;
 
                DataTable table3 = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table3);
 
                dataGridView4.DataSource = table3;
                //------------------------------------------------------------------//
            
            }
            catch (Exception ex) { MessageBox.Show("Ошибка:"+ ex.Message); }
            }
 
        private void button1_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
         
            f2.textBox1.Visible = true;
            f2.textBox2.Visible = true;
            f2.textBox3.Visible = true;
            f2.label1.Text = "Id_city";
            f2.label1.Visible = true;
            f2.label2.Text = "Id_firm";
            f2.label3.Text = "firma";
            f2.label2.Visible = true;
            f2.label3.Visible = true;
        }
 
       private void button2_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
            f2.textBox1.Visible = true;
            f2.textBox2.Visible = true;
            f2.textBox3.Visible = true;
            f2.label1.Text = dataGridView1.Columns[0].HeaderText;
            f2.label2.Text = dataGridView1.Columns[1].HeaderText;
            f2.label3.Text = dataGridView1.Columns[2].HeaderText;
            f2.label1.Visible = true;
            f2.label2.Visible = true;
            f2.label3.Visible = true;
            
            if (f2.ShowDialog() == DialogResult.OK)
            {
                string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
                MySqlConnection myConnection = new MySqlConnection(Connect);
                myConnection.Open();
                string sql = "INSERT INTO `firma` (`id_sity`, `id_firma`, `name_firma`) VALUES (";
                sql += string.Format("'{0}', NULL, '{1}')",f2.textBox1.Text, f2.textBox3.Text);
                MySqlCommand firmadd = new MySqlCommand(sql);
           
                MySqlCommand mc = new MySqlCommand();
                mc.CommandType = CommandType.Text;
                mc.CommandText = sql;
                mc.Connection = myConnection;
                mc.ExecuteNonQuery();
                dataGridView1.DataSource = "";
                string sel = "select * from firma";
                MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
                MySqlDataAdapter adapter = new MySqlDataAdapter();
                adapter.SelectCommand = mc2;
 
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
 
                dataGridView1.DataSource = table;
           
                myConnection.Close();
 
 
            }
            else { }
        }
 
 
        private void button5_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
 
            f2.textBox1.Visible = true;
            f2.textBox2.Visible = true;
            f2.textBox3.Visible = true;
            f2.textBox4.Visible = true;
            f2.textBox5.Visible = true;
            f2.textBox6.Visible = true;
            f2.label1.Text = dataGridView2.Columns[0].HeaderText;
            f2.label2.Text = dataGridView2.Columns[1].HeaderText;
            f2.label3.Text = dataGridView2.Columns[2].HeaderText;
            f2.label4.Text = dataGridView2.Columns[3].HeaderText;
            f2.label5.Text = dataGridView2.Columns[4].HeaderText;
            f2.label6.Text = dataGridView2.Columns[4].HeaderText;
            f2.label1.Visible = true;
            f2.label2.Visible = true;
            f2.label3.Visible = true;
            f2.label4.Visible = true;
            f2.label5.Visible = true;
            f2.label6.Visible = true;
            if (f2.ShowDialog() == DialogResult.OK)
            {
                string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
                MySqlConnection myConnection = new MySqlConnection(Connect);
                myConnection.Open();
                string sql = "INSERT INTO `rezume` (`id_sity`, `id_special`, `id_rezume`, `kontakt_tel`, `z_p`, `dop_info`) VALUES (";
                sql += string.Format("'{0}','{1}', NULL,'{2}','{3}','{4}')", f2.textBox1.Text, f2.textBox2.Text, f2.textBox4.Text, f2.textBox5.Text,f2.textBox6.Text);
                MySqlCommand firmadd = new MySqlCommand(sql);
 
                MySqlCommand mc = new MySqlCommand();
                mc.CommandType = CommandType.Text;
                mc.CommandText = sql;
                mc.Connection = myConnection;
                mc.ExecuteNonQuery();
                dataGridView1.DataSource = "";
                string sel = "select * from rezume";
                MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
                MySqlDataAdapter adapter = new MySqlDataAdapter();
                adapter.SelectCommand = mc2;
 
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
 
                dataGridView2.DataSource = table;
 
                myConnection.Close();
 
 
            }
            else { }
        }
        
 
        private void button3_Click(object sender, EventArgs e)
        {
            string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            myConnection.Open();
            string sql = string.Format("delete from `firma` where id_firma={0}", dataGridView1.CurrentCell.RowIndex + 1);
          
            MySqlCommand mc = new MySqlCommand();
            mc.CommandType = CommandType.Text;
            mc.CommandText = sql;
            mc.Connection = myConnection;
            mc.ExecuteNonQuery();
            myConnection.Close();
            string sel = string.Format("select * from  firma");
            MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            adapter.SelectCommand = mc2;
 
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);
 
            dataGridView1.DataSource = table;
        }
 
       
 
        private void dataGridView1_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e)
        {
 
        }
 
        private void button11_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
 
            f2.textBox1.Visible = true;
            f2.textBox2.Visible = true;
            f2.label1.Text = dataGridView4.Columns[0].HeaderText;
            f2.label2.Text = dataGridView4.Columns[1].HeaderText;
            f2.label1.Visible = true;
            f2.label2.Visible = true;
 
            if (f2.ShowDialog() == DialogResult.OK)
            {
                string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
                MySqlConnection myConnection = new MySqlConnection(Connect);
                myConnection.Open();
                string sql = "INSERT INTO `special` (`id_special`, `name_special`) VALUES (";
                sql += string.Format("NULL,'{0}')", f2.textBox2.Text);
                MySqlCommand firmadd = new MySqlCommand(sql);
 
                MySqlCommand mc = new MySqlCommand();
                mc.CommandType = CommandType.Text;
                mc.CommandText = sql;
                mc.Connection = myConnection;
                mc.ExecuteNonQuery();
                dataGridView4.DataSource = "";
                string sel = "select * from special";
                MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
                MySqlDataAdapter adapter = new MySqlDataAdapter();
                adapter.SelectCommand = mc2;
 
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
 
                dataGridView4.DataSource = table;
 
                myConnection.Close();
 
 
            }
            else { }
        }
 
        private void button8_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
 
            f2.textBox1.Visible = true;
            f2.textBox2.Visible = true;
            f2.label1.Text = dataGridView3.Columns[0].HeaderText;
            f2.label2.Text = dataGridView3.Columns[1].HeaderText;
            f2.label1.Visible = true;
            f2.label2.Visible = true;
 
            if (f2.ShowDialog() == DialogResult.OK)
            {
                string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
                MySqlConnection myConnection = new MySqlConnection(Connect);
                myConnection.Open();
                string sql = "INSERT INTO `sity` (`id_sity`, `name_sity`) VALUES (";
                sql += string.Format("NULL,'{0}')", f2.textBox2.Text);
                MySqlCommand firmadd = new MySqlCommand(sql);
 
                MySqlCommand mc = new MySqlCommand();
                mc.CommandType = CommandType.Text;
                mc.CommandText = sql;
                mc.Connection = myConnection;
                mc.ExecuteNonQuery();
                dataGridView3.DataSource = "";
                string sel = "select * from sity";
                MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
                MySqlDataAdapter adapter = new MySqlDataAdapter();
                adapter.SelectCommand = mc2;
 
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
 
                dataGridView3.DataSource = table;
 
                myConnection.Close();
 
 
            }
            else { }
 
        }
 
        private void button14_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
 
            f2.textBox1.Visible = true;
            f2.textBox2.Visible = true;
            f2.textBox3.Visible = true;
            f2.textBox4.Visible = true;
            f2.textBox5.Visible = true;
            f2.textBox6.Visible = true;
            f2.label1.Text = dataGridView5.Columns[0].HeaderText;
            f2.label2.Text = dataGridView5.Columns[1].HeaderText;
            f2.label3.Text = dataGridView5.Columns[2].HeaderText;
            f2.label4.Text = dataGridView5.Columns[3].HeaderText;
            f2.label5.Text = dataGridView5.Columns[4].HeaderText;
            f2.label6.Text = dataGridView5.Columns[5].HeaderText;
            f2.label1.Visible = true;
            f2.label2.Visible = true;
            f2.label3.Visible = true;
            f2.label4.Visible = true;
            f2.label5.Visible = true;
            f2.label6.Visible = true;
            if (f2.ShowDialog() == DialogResult.OK)
            {
                string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
                MySqlConnection myConnection = new MySqlConnection(Connect);
                myConnection.Open();
                string sql = "INSERT INTO `vacans` (`id_firma`, `id_special`, `id_vac`, `kontakt_tel`, `z_p`, `dop_info`) VALUES (";
                sql += string.Format("'{0}','{1}', NULL,'{2}','{3}','{4}')", f2.textBox1.Text, f2.textBox2.Text, f2.textBox4.Text, f2.textBox5.Text, f2.textBox6.Text);
                MySqlCommand firmadd = new MySqlCommand(sql);
 
                MySqlCommand mc = new MySqlCommand();
                mc.CommandType = CommandType.Text;
                mc.CommandText = sql;
                mc.Connection = myConnection;
                mc.ExecuteNonQuery();
                dataGridView5.DataSource = "";
                string sel = "select * from vacans";
                MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
                MySqlDataAdapter adapter = new MySqlDataAdapter();
                adapter.SelectCommand = mc2;
 
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
 
                dataGridView5.DataSource = table;
 
                myConnection.Close();
 
 
            }
            else { }
        }
 
        private void button6_Click(object sender, EventArgs e)
        {
            string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            myConnection.Open();
            string sql = string.Format("delete from `rezume` where id_rezume={0}", dataGridView2.CurrentCell.RowIndex + 1);
 
            MySqlCommand mc = new MySqlCommand();
            mc.CommandType = CommandType.Text;
            mc.CommandText = sql;
            mc.Connection = myConnection;
            mc.ExecuteNonQuery();
            myConnection.Close();
            string sel = string.Format("select * from  rezume");
            MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            adapter.SelectCommand = mc2;
 
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);
 
            dataGridView2.DataSource = table;
        }
 
        private void button7_Click(object sender, EventArgs e)
        {
            string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            myConnection.Open();
            string sql = string.Format("delete from `sity` where id_sity={0}", dataGridView3.CurrentCell.RowIndex + 1);
 
            MySqlCommand mc = new MySqlCommand();
            mc.CommandType = CommandType.Text;
            mc.CommandText = sql;
            mc.Connection = myConnection;
            mc.ExecuteNonQuery();
            myConnection.Close();
            string sel = string.Format("select * from  sity");
            MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            adapter.SelectCommand = mc2;
 
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);
 
            dataGridView3.DataSource = table;
        }
 
        private void button10_Click(object sender, EventArgs e)
        {
            string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            myConnection.Open();
            string sql = string.Format("delete from `special` where id_special={0}", dataGridView4.CurrentCell.RowIndex + 1);
 
            MySqlCommand mc = new MySqlCommand();
            mc.CommandType = CommandType.Text;
            mc.CommandText = sql;
            mc.Connection = myConnection;
            mc.ExecuteNonQuery();
            myConnection.Close();
            string sel = string.Format("select * from  special");
            MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            adapter.SelectCommand = mc2;
 
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);
 
            dataGridView4.DataSource = table;
        }
 
        private void button13_Click(object sender, EventArgs e)
        {
            string Connect = "Database=praktika;Data Source=localhost;User Id=root;Password=";
            MySqlConnection myConnection = new MySqlConnection(Connect);
            myConnection.Open();
            string sql = string.Format("delete from `vacans` where id_vac={0}", dataGridView5.CurrentCell.RowIndex + 1);
 
            MySqlCommand mc = new MySqlCommand();
            mc.CommandType = CommandType.Text;
            mc.CommandText = sql;
            mc.Connection = myConnection;
            mc.ExecuteNonQuery();
            myConnection.Close();
            string sel = string.Format("select * from   vacans");
            MySqlCommand mc2 = new MySqlCommand(sel, myConnection);
 
 
            MySqlDataAdapter adapter = new MySqlDataAdapter();
            adapter.SelectCommand = mc2;
 
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            adapter.Fill(table);
 
            dataGridView5.DataSource = table;
        }
 
        
 
    }
}