/// <summary>
/// Export from SQL-Server Customers table selected fields.
/// The same can be done by writing a method for exporting to Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdExportFromSqlServerToMsAccessDynamic_Click(object sender, EventArgs e)
{
var columnList = clbColumnNames.CheckedIColumnDetailsList();
if (columnList.Count > 0)
{
/*
* if chkBracketed is checked wrap field names with [], otherwise
* use field names without brackets.
*/
var fields = chkBracketed.Checked
? string.Join(",", columnList.Select(col => col.NameBracketed))
: string.Join(",", columnList.Select(col => col.Name));
var ops = new SqlServerOperations();
if (!(ops.CopyToApplicationFolder(_accessCompanyFileName)))
{
MessageBox.Show(ops.LastExceptionMessage);
return;
}
int rowCount = 0;
MessageBox.Show(
ops.ExportAllCustomersToAccess(_accessCompanyFileName, countriesComboxAccess2.Text, fields, ref rowCount)
? $"Exported {rowCount} rows."
: ops.LastExceptionMessage);
}
else
{
MessageBox.Show("Please select one or more fields and try again");
}
}
/// <summary>
/// Export all customer records or by country
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdExportFromSqlServerToMsAccess_Click(object sender, EventArgs e)
{
var ops = new SqlServerOperations();
if (!(ops.CopyToApplicationFolder(_accessCompanyFileName)))
{
MessageBox.Show(ops.LastExceptionMessage);
return;
}
int rowCount = 0;
MessageBox.Show(
ops.ExportAllCustomersToAccess(_accessCompanyFileName, countriesComboxAccess1.Text, ref rowCount)
? $"Exported {rowCount} rows."
: ops.LastExceptionMessage);
}
