Day 29 -资料库应用小程序菜单显示(内涵程序码)

废话不多说直接开始

我们点选菜单按钮会连结到这个表单

全域变数

   string MyConnection2 = "datasource=122.0.0.0;port=3366;username=root;password=;Allow Zero Datetime=True;";
        private string dbHost = "localhost";
        private string dbPort = "3306";
        private string dbUser = "root";
        private string dbPassword = ""; 
        private string dbName = "db85cc"; 
        MySqlConnection conn = null;
        MySqlDataAdapter mySqlDataAdapter;
        DataSet ds;

按钮按照菜单内商品去做分类

面包按钮:

 try
                {

                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='bread'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2); 
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable;             
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }

切片蛋糕:

    try
                {

                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='cake'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable;          
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }

大杯饮料:

     try
                {

                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='drinkL'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2); 
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable; 
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }

中杯饮料:

try
                { 
                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='drinkM'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable;  
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }

小杯饮料:

 try
                {
                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='drinkS'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable;           
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }

六寸蛋糕:

try
                {
                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='cake6'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable; 
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }

八寸蛋糕:

try
                {
                string Query = "select product.Product_name,product.Product_price from db85cc.product where product.prodict_id='cake8'";
                MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dgvmenu.DataSource = dTable; 
                }
            catch (Exception ex)
                {
                MessageBox.Show(ex.Message);
                }