private void menuItem2_Click(object sender, System.EventArgs e)
{
conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=../../storeDB.mdb");
command = new OleDbCommand("SELECT Products.* FROM Products", conn);
adapter = new OleDbDataAdapter();
dataset = new DataSet();
S = Path.GetFullPath(@"../../image");
conn.Open();
saveFileDialog1.FileName = "DBImageExample.pdf";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
sdReport1.FileName = saveFileDialog1.FileName;
sdReport1.BeginDoc();
adapter.SelectCommand = command;
adapter.Fill(dataset, "customer");
while (Pos < dataset.Tables[0].Rows.Count)
{
sdReport1.Print(sdPage1);
}
statusBar1.Text = "Writing document...";
conn.Close();
sdReport1.EndDoc();
statusBar1.Text = "End...";
}
}
private void button1_Click(object sender, System.EventArgs e)
{
sdReport1.BeginDoc();
sdReport1.Print(sdPage1);
sdReport1.EndDoc();
Process Acro = Process.Start("default.pdf");
Acro.WaitForExit();
Acro.Close();
}
