Разработка программы по работе с базой данных «Ресторан»

                {

                    mySqlDataReaderDataGridView.Columns.Add(gl.MDR.GetName(i), gl.MDR.GetName(i));

                    mySqlDataReaderDataGridView.Columns[i].DataPropertyName = gl.t1.Columns[i].ToString();

                }

            }

            gl.MDR.Close();

        }

        private void общаяToolStripMenuItem1_Click(object sender, EventArgs e)

        {

            button1.Visible = true;

            button4.Visible = true;

            string s = "select dostavka.fio,adres,tel,dostavka,zakazy.time,bluda " +

                      "from dostavka,zakazy " +

                      "where dostavka.fio=zakazy.fio;";

            gl.cmd.CommandText = s;

            int i;

            gl.MDR = gl.cmd.ExecuteReader();

            gl.DB = new DataSet();

            gl.t2 = gl.DB.Tables.Add("cafe");

            if (gl.t2 == null)

            {

                gl.t2 = gl.DB.Tables.Add("cafe");

                for (i = 0; i < gl.MDR.FieldCount; i++)

                {

                    gl.col = new DataColumn(gl.MDR.GetName(i), gl.MDR.GetFieldType(i));

                    gl.t2.Columns.Add(gl.col);

                }

            }

            else

            {

                gl.t2.Clear();

            }

            for (i = 0; i < gl.MDR.FieldCount; i++)

            {

                gl.col = new DataColumn(gl.MDR.GetName(i),

                                gl.MDR.GetFieldType(i));

                gl.t2.Columns.Add(gl.col);

            }            while (gl.MDR.Read())

            {

                gl.r = gl.t2.NewRow();

                for (i = 0; i < gl.MDR.FieldCount; i++)

                    gl.r[i] = gl.MDR.GetString(i);

                gl.t2.Rows.Add(gl.r); 

            }

            mySqlDataReaderBindingSource.DataSource = gl.t2;

            if (mySqlDataReaderDataGridView.Columns.Count != 0)

            { mySqlDataReaderDataGridView.Columns.Clear(); };

            {

                for (i = 0; i < gl.MDR.FieldCount; i++)

                {

                    mySqlDataReaderDataGridView.Columns.Add(gl.MDR.GetName(i), gl.MDR.GetName(i));

                    mySqlDataReaderDataGridView.Columns[i].DataPropertyName = gl.t2.Columns[i].ToString();

                }

            }

            gl.MDR.Close();               

        } 

        private void mySqlDataReaderDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)

        {

           

            int n;

            n = mySqlDataReaderDataGridView.CurrentCell.RowIndex;

            textBox1.Text = mySqlDataReaderDataGridView.Rows[n].Cells[0].Value.ToString();

            textBox2.Text = mySqlDataReaderDataGridView.Rows[n].Cells[1].Value.ToString();

            textBox3.Text = mySqlDataReaderDataGridView.Rows[n].Cells[2].Value.ToString();

            textBox4.Text = mySqlDataReaderDataGridView.Rows[n].Cells[3].Value.ToString();

            textBox5.Text = mySqlDataReaderDataGridView.Rows[n].Cells[4].Value.ToString();

            textBox6.Text = mySqlDataReaderDataGridView.Rows[n].Cells[5].Value.ToString();

                      } 

        private void button1_Click(object sender, EventArgs e)

        { 

            button2.Visible = true;

            button3.Visible = false;

            button5.Visible = false;

            panel1.Visible = true;

            checkBox1.Visible = true;

            checkBox2.Visible = true;

            checkBox3.Visible = true;

           

            checkBox4.Visible = true;

            checkBox5.Visible = true;

            checkBox6.Visible = true;

                       button4.Visible = true;

            label1.Visible = false;

        } 

        private void button4_Click(object sender, EventArgs e)

        {           

            button3.Visible = true;

            button5.Visible = true;

            button2.Visible = false;

            panel1.Visible = true;

            checkBox1.Visible = false;

            checkBox2.Visible = false;

            checkBox3.Visible = false;

          

            checkBox4.Visible = false;

            checkBox5.Visible = false;

            checkBox6.Visible = false;

          

            label2.Visible = true;

            label1.Visible = false;        

                  } 

       private void поискToolStripMenuItem_Click(object sender, EventArgs e)

        {

            this.Close();

        } 
 

        private void button5_Click(object sender, EventArgs e)

        {

            gl.cmd.CommandText = "delete from dostavka where dostavka.fio='" + textBox1.Text + "';";

            gl.cmd.ExecuteNonQuery();

            gl.cmd.CommandText = "delete from zakazy where zakazy.fio='" + textBox1.Text + "';";

            gl.cmd.ExecuteNonQuery();

            this.общаяToolStripMenuItem1_Click(sender, e);

        }                    

    }

} 

public static class gl

{

    public static MySql.Data.MySqlClient.MySqlConnection Connect = new MySql.Data.MySqlClient.MySqlConnection();