Разработка информационной системы «Автопарковка» с использованием клиент-серверной технологи

            com.Parameters["rn"].Value = textBox10.Text;

            com.Parameters.Add("SURNAME", OleDbType.Char);

            com.Parameters["SURNAME"].Value = textBox9.Text;

            com.Parameters.Add("NAME", OleDbType.Char);

            com.Parameters["NAME"].Value = textBox8.Text;

            com.Parameters.Add("SECOND_NAME", OleDbType.Char);

            com.Parameters["SECOND_NAME"].Value = textBox7.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.cLIENTSTableAdapter.Fill(this.dataSet1.CLIENTS);

            con.Close();

            textBox10.Text = "";

            textBox9.Text = "";

            textBox8.Text = "";

            textBox7.Text = "";

        } 

        private void button14_Click(object sender, EventArgs e)

        {

            //Поиск записи

            tRANSPORTBindingSource.Filter = "MARK like '" + textBox20.Text + "%'";

        } 

        private void button10_Click(object sender, EventArgs e)

        {

            //Фильтрация записи

            if (radioButton4.Checked == true)

                tRANSPORTBindingSource.Filter = "MARK like '%" + textBox11.Text + "%'";

         

        } 

        private void button13_Click(object sender, EventArgs e)

        {

            //Добавление записи

            tRANSPORTBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE INS_TRANSPORT (:MARK, :COLOUR, :STATE_NUM, :RN_CLIENTS)", con, trans);

            com.Parameters.Add("MARK", OleDbType.Char);

            com.Parameters["MARK"].Value = textBox19.Text;

            com.Parameters.Add("COLOUR", OleDbType.Char);

            com.Parameters["COLOUR"].Value = textBox18.Text;

            com.Parameters.Add("STATE_NUM", OleDbType.Char);

            com.Parameters["STATE_NUM"].Value = textBox17.Text;

            com.Parameters.Add("RN_CLIENTS", OleDbType.Char);

            com.Parameters["RN_CLIENTS"].Value = textBox21.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.tRANSPORTTableAdapter.Fill(this.dataSet1.TRANSPORT);

            con.Close();

            textBox19.Text = "";

            textBox18.Text = "";

            textBox17.Text = "";

            textBox21.Text = "";

        } 

        private void button12_Click(object sender, EventArgs e)

        {

            //Изменение записи

            tRANSPORTBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE UPD_TRANSPORT (:rn, :COLOUR, :MARK, :STATE_NUM, :RN_CLIENTS)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox13.Text;

            com.Parameters.Add("COLOUR", OleDbType.Char);

            com.Parameters["COLOUR"].Value = textBox15.Text;

            com.Parameters.Add("MARK", OleDbType.Char);

            com.Parameters["MARK"].Value = textBox16.Text;

            com.Parameters.Add("STATE_NUM", OleDbType.Char);

            com.Parameters["STATE_NUM"].Value = textBox14.Text;

            com.Parameters.Add("RN_CLIENTS", OleDbType.Char);

            com.Parameters["RN_CLIENTS"].Value = textBox22.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.tRANSPORTTableAdapter.Fill(this.dataSet1.TRANSPORT);

            con.Close();

            textBox13.Text = "";

            textBox16.Text = "";

            textBox15.Text = "";

            textBox14.Text = "";

            textBox22.Text = "";

        } 

        private void button11_Click(object sender, EventArgs e)

        {

            //Удаление записи

            tRANSPORTBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE DEL_TRANSPORT (:rn)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox12.Text;

                   trans.Commit();

            com.ExecuteScalar();

            this.tRANSPORTTableAdapter.Fill(this.dataSet1.TRANSPORT);

            con.Close();

            textBox12.Text = "";

          } 

        private void button9_Click(object sender, EventArgs e)

        {

            //Очистка всех полей

            textBox12.Text = "";

            textBox13.Text = "";

            textBox11.Text = "";

            textBox14.Text = "";