private void timer1_Tick(object sender, EventArgs e) { dttable1 = TestToConnectMySQLServer.FillData(sql1, connection); dttable2 = TestToConnectMySQLServer.FillData(sql2, connection); dttable3 = TestToConnectMySQLServer.FillData(sql3, connection); dttable4 = TestToConnectMySQLServer.FillData(sql4, connection); GenerateTable(comboBox1.Text); textBox1.Text = ("Last Refresh: " + DateTime.Now.ToLongTimeString()); }
private void Form1_Load(object sender, EventArgs e) { comboBox2.Text = "5 min"; comboBox3.Text = "3"; textBox1.Text = ("Last Refresh: " + DateTime.Now.ToLongTimeString()); dttable1 = TestToConnectMySQLServer.FillData(sql1, connection); dttable2 = TestToConnectMySQLServer.FillData(sql2, connection); dttable3 = TestToConnectMySQLServer.FillData(sql3, connection); dttable4 = TestToConnectMySQLServer.FillData(sql4, connection); timer1.Enabled = true; comboBox1.SelectedItem = "2-Shift"; }
private void button3_Click(object sender, EventArgs e) { dttable1 = TestToConnectMySQLServer.FillData(sql1, connection); dttable2 = TestToConnectMySQLServer.FillData(sql2, connection); dttable3 = TestToConnectMySQLServer.FillData(sql3, connection); dttable4 = TestToConnectMySQLServer.FillData(sql4, connection); DataTable dtReturn = Pivot.GetFixedPivotTable(dttable2, "Date", "Line", "SA_SN", "0", "Count", columnHeaderInput); DataTable dtReturn2 = Pivot.GetFixedPivotTable(dttable3, "Date", "Line", "SA_SN", "0", "Count", columnHeaderInput); dataGridView1.DataSource = dttable1.DefaultView; dataGridView2.DataSource = dtReturn.DefaultView; dataGridView3.DataSource = dtReturn2.DefaultView; dataGridView4.DataSource = dttable4.DefaultView; Pivot.GetDivisionCellFormat(dataGridView2, dataGridView3, rejectHighlightQty); dataGridView3.DataSource = null; dataGridView3.DataSource = Pivot.GetPercentagePivotTable(dtReturn2, "Total").DefaultView; textBox1.Text = ("Last Refresh: " + DateTime.Now.ToLongTimeString()); }