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