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

using System.Windows.Forms; 

namespace Автопарковка

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        } 

        private void Form1_Load(object sender, EventArgs e)

        {

            // TODO: This line of code loads data into the 'dataSet1.VMAGAZINE' table. You can move, or remove it, as needed.

            this.vMAGAZINETableAdapter.Fill(this.dataSet1.VMAGAZINE);

            // TODO: This line of code loads data into the 'dataSet1.MAGAZINE_EVENTS' table. You can move, or remove it, as needed.

            this.eMPLOYERSTableAdapter.Fill(this.dataSet1.EMPLOYERS);

            // TODO: This line of code loads data into the 'dataSet1.MESTO_PARKING' table. You can move, or remove it, as needed.

            this.mESTO_PARKINGTableAdapter.Fill(this.dataSet1.MESTO_PARKING);

            // TODO: This line of code loads data into the 'dataSet1.TRANSPORT' table. You can move, or remove it, as needed.

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

            // TODO: This line of code loads data into the 'dataSet1.CLIENTS' table. You can move, or remove it, as needed.

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

        } 

        private void выходToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Close();

        } 

        private void button6_Click(object sender, EventArgs e)

        {

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

            textBox1.Text = "";

            textBox2.Text = "";

            textBox3.Text = "";

            textBox4.Text = "";

            textBox5.Text = "";

            textBox6.Text = "";

            textBox7.Text = "";

            textBox8.Text = "";

            textBox9.Text = "";

            textBox10.Text = ""; 

        } 

        private void button7_Click(object sender, EventArgs e)

        {

            //Показать все записи таблицы

            cLIENTSBindingSource.Filter = "";

        } 

        private void button4_Click(object sender, EventArgs e)

        {

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

            cLIENTSBindingSource.Filter = "SURNAME like '" + textBox2.Text + "%'";

        } 

        private void button5_Click(object sender, EventArgs e)

        {

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

            if (radioButton1.Checked == true)

                cLIENTSBindingSource.Filter = "SURNAME like '%" + textBox3.Text + "%'";

            if (radioButton2.Checked == true)

                cLIENTSBindingSource.Filter = "NAME like '%" + textBox3.Text + "%'"; 

        } 

        private void button3_Click(object sender, EventArgs e)

        {

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

            cLIENTSBindingSource.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_CLIENTS (:SURNAME, :NAME, :SECOND_NAME)", con, trans);

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

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

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

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

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

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

            trans.Commit();

            com.ExecuteScalar();

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

            con.Close();

            textBox4.Text = "";

            textBox5.Text = "";

            textBox6.Text = ""; 

        } 

        private void button1_Click(object sender, EventArgs e)

        {

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

            cLIENTSBindingSource.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_CLIENT(:rn)", con, trans);

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

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

            trans.Commit();

            com.ExecuteScalar();

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

            con.Close();

            textBox1.Text = ""; 

        } 

        private void button2_Click(object sender, EventArgs e)

        {

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

            cLIENTSBindingSource.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_CLIENTS (:rn, :SURNAME, :NAME, :SECOND_NAME)", con, trans);

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