01.protected void Page_Load(object sender, EventArgs e)
02. {
03. ConnectionInfo crConnectionInfo = new ConnectionInfo();
04. crConnectionInfo.ServerName = "localhost";
05. crConnectionInfo.DatabaseName = "ฐานข้อมูล";
06. crConnectionInfo.UserID = "ไอดี";
07. crConnectionInfo.Password = "รหัสผ่าน";
08. ReportDocument reportDocument1 = new ReportDocument();
09. reportDocument1.Load(Server.MapPath("CrystalReport1.rpt"));
10. TableLogOnInfos crTableLogonInfos = new TableLogOnInfos();
11. TableLogOnInfo crTableLogonInfo = new TableLogOnInfo();
12. foreach (CrystalDecisions.CrystalReports.Engine.Table table in reportDocument1.Database.Tables)
13. {
14. crTableLogonInfo.TableName = table.Name;
15. crTableLogonInfo.ConnectionInfo = crConnectionInfo;
16. crTableLogonInfos.Add(crTableLogonInfo);
17. table.ApplyLogOnInfo(crTableLogonInfo);
18. }
19. CrystalReportViewer1.LogOnInfo = crTableLogonInfos;
20.
21. CrystalReportViewer1.ReportSource = reportDocument1;
22. }
