//Красим таблицу private void dataGridView1_LoadingRow(object sender, DataGridRowEventArgs e) { DGV_Info dgv = (DGV_Info)e.Row.DataContext; using (MySqlConnection connection = new MySqlConnection(conn)) { connection.Open(); MySqlCommand command = new MySqlCommand($"SELECT COUNT(*) FROM journal_wisiting WHERE id_journal=\"{dgv.NumberZapis}\"", connection); if (Convert.ToInt32(command.ExecuteScalar()) == 1) { e.Row.Background = new SolidColorBrush(Color.FromRgb(10, 142, 160)); } else { e.Row.Background = new SolidColorBrush(Color.FromRgb(255, 200, 69)); } } /* * DGV_Info dgv = (DGV_Info)e.Row.DataContext; * if (dgv.DateReceipt == "23.11.12") * { * e.Row.Background = new SolidColorBrush(Colors.Aquamarine); * } */ }
/// <summary> /// BTNProcessPDF_Click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BTNProcessFillDGV_Click(object sender, EventArgs e) { //var fileType = (sender as Button).Name.ToLower(); DGV_Info.DataSource = null; //myPDFList.Clear(); DGV_Info.Rows.Clear(); DGV_Info.Refresh(); if ((TBX_XCELFile.Text != null) && (TBX_XCELFile.Text.Trim() != "")) { var form2 = new FRM_XCELType(); if (form2.ShowDialog() == System.Windows.Forms.DialogResult.OK) { myIPAMList.Clear(); curXCELType = form2.XCELType; ReadXCELFile(TBX_XCELFile.Text.Trim(), curXCELType); if (myIPAMList.Count > 0) { DGV_Info.DataSource = myIPAMList; LBL_PDF.Text = curXCELType + " CBS File Type"; } //BTN_ProcessXCEL.Visible = false; BTN_UpdatePDF.Visible = true; BTN_SaveIPAM.Visible = true; //BTN_UpdatePDF.Visible = true; } else { MessageBox.Show("Action Cancelled"); } } else { MessageBox.Show("No file selected"); } }