01.DataSet ds = new DataSet();
02.CRP.CrpPr1_Map crpPR1 = new CRP.CrpPr1_Map();
03. MySqlDataReader dtReader;
04. strSQL = "SELECT cus_id,cus_map FROM customers WHERE customers.onshow = 1 AND cus_id BETWEEN '" + cbbCusStartID.Text + "' AND '" + cbbCusEndID.Text + "' GROUP BY customers.cus_id ORDER BY customers.cus_id";
05. dtAdapter = new MySqlDataAdapter(strSQL, hm.objConn());
06. dtAdapter.Fill(ds, "customers");
07. dtReader = dtAdapter.SelectCommand.ExecuteReader();
08.
09. if (dtReader.HasRows)
10. {
11. while (dtReader.Read())
12. {
13. string path = hm.DirectoryIMG + dtReader["cus_map"].ToString();
14.
15. FileStream FilStr = new FileStream(path, FileMode.Open);
16. BinaryReader BinRed = new BinaryReader(FilStr);
17.
18. DataRow dr = ds.Tables["customers"].NewRow();
19.
20. dr["cus_id"] = dtReader["cus_id"];
21.
22. dr["cus_map"] = BinRed.ReadBytes((int)BinRed.BaseStream.Length);
23. ds.Tables["customers"].Rows.Add(dr);
24.
25.
26. FilStr.Close();
27. BinRed.Close();
28. }
29. dtReader.Close();
30. hm.closeConn();
31. }
32. crpPR1.Database.Tables["customers"].SetDataSource(ds.Tables["customers"]);
33. frmDocPt.crystalReportViewer1.ReportSource = crpPR1;
34. crpPR1.Refresh();
