コード例 #1
0
 public Ticket()
 {
     this.StartPosition = FormStartPosition.CenterScreen;
     InitializeComponent();
     mysqlConn = new customerDbConn();
     mysqlConn.connect();
     if (mysqlConn.connOpen() == true)
     {
         dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `poll_main`").Tables[0];
         dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `poll_options`").Tables[0];
         dataGridView3.DataSource = mysqlConn.qry("SELECT * FROM `poll_votes`").Tables[0];
     }
     mysqlConn.connClose();
 }
        public Bottom()
        {
            this.StartPosition = FormStartPosition.CenterScreen;
            mysqlConn          = new customerDbConn();
            mysqlConn.connect();
            InitializeComponent();

            if (mysqlConn.connOpen() == true)
            {
                dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `sales`").Tables[0];
                dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `orderdetails`").Tables[0];
                dataGridView3.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0];
            }
            mysqlConn.connClose();
        }