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; } }