private void Page_Loaded(object sender, RoutedEventArgs e) { MySqlDataAdapter adapterCase = CasesDB.GetDataAdapterCases(); DataTable dtCase = new DataTable("datamuncher_case"); adapterCase.Fill(dtCase); dgCases.ItemsSource = dtCase.DefaultView; /* * using (dt = new DataTable()) * { * sqlda.Fill(dt); * dataGridView1.DataSource = dt; * } */ }
private void export(string caseNumber = "") { MySqlDataAdapter adapterCase = CasesDB.GetDataAdapterCases(caseNumber); DataTable dtCase = new DataTable("zaken"); adapterCase.Fill(dtCase); XLWorkbook workbook = new XLWorkbook(); workbook.Worksheets.Add(dtCase); if (chkIncFilenames.IsChecked.HasValue && chkIncFilenames.IsChecked.Value) { foreach (DataRow row in dtCase.Rows) { string tmpCase = row[0].ToString(); MySqlDataAdapter adapterCaseContent = CasesDB.GetDataAdapterCaseContent(tmpCase); DataTable dtCaseContent = new DataTable($"zaak_{tmpCase}"); adapterCaseContent.Fill(dtCaseContent); workbook.Worksheets.Add(dtCaseContent); } } SaveFileDialog ofd = new SaveFileDialog() { RestoreDirectory = true, DefaultExt = "xlsx", Filter = "Excel Files Files (*.xlsx)|*.xlsx|All Files (*.*)|*.*", }; if (ofd.ShowDialog() == DialogResult.OK) { workbook.SaveAs(ofd.FileName); } }