public void ExportDueInvoices()
{
SqlCompactConnection conn = new SqlCompactConnection();
SalesInvoiceHeader sih = new SalesInvoiceHeader();
DataSet ds = new DataSet();
int count = 0;
try
{
ds = sih.GetInvoicesBalance();
count = ds.Tables[0].Rows.Count;
progressBar1.Minimum = 0;
progressBar1.Maximum = count;
lblStatus.Text = "Exporting Invoices (" + count.ToString() + " records)";
RefreshForm();
conn.DropInvoicesBalanceTable();
//progressBar1.Value = count/5 ;
RefreshForm();
conn.SynchForm = this;
conn.CreateInvoicesBalanceTable();
//progressBar1.Value = count * 2/5;
RefreshForm();
if (ds != null)
{
conn.InsertInvoicesBalance(ds.Tables[0]);
}
//progressBar1.Value = count ;
//RefreshForm();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.CloseDatabase();
conn = null;
}
}