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!");
}
}
