private void DBInsert(object sender, RoutedEventArgs e) { if (mysqlDataSet == null) { return; } var dlg = new InsertDlg(mysqlDataSet.Tables[0].Columns); if (dlg.ShowDialog() == true) { var row = mysqlDataSet.Tables[0].NewRow(); int colId = 0; foreach (var itm in dlg.Items) { if (itm.Value == null) { row[colId] = DBNull.Value; } else { row[colId] = itm.Value; } colId++; } mysqlDataSet.Tables[0].Rows.Add(row); mysqlAdapter.Update(mysqlDataSet); MessageBox.Show("Inserted!"); } }
private void ExcelAddNew(object sender, RoutedEventArgs e) { if (excelView == null) { return; } var dlg = new InsertDlg(excelView.Table.Columns); if (dlg.ShowDialog() == true) { var row = excelView.Table.NewRow(); int colId = 0; foreach (var itm in dlg.Items) { if (itm.Value == null) { if (excelView.Table.Columns[colId].DataType == typeof(string)) { row[colId] = ""; } else { row[colId] = Activator.CreateInstance(excelView.Table.Columns[colId].DataType); } } else { row[colId] = itm.Value; } colId++; } excelView.Table.Rows.Add(row); excelAdapter.Update(excelDataSet); MessageBox.Show("Finished!"); } }