01.ReportDocument cryRpt = new ReportDocument();
02.TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
03.TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
04.ConnectionInfo crConnectionInfo = new ConnectionInfo();
05.Tables CrTables;
06.
07.cryRpt.Load(MapPath("CrystalReport.rpt"));
08.crConnectionInfo.ServerName = "ICELand";
09.crConnectionInfo.DatabaseName = "MiniOPT";
10.crConnectionInfo.UserID = "sa";
11.crConnectionInfo.Password = "121212";
12.
13.CrTables = cryRpt.Database.Tables;
14.foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
15.{
16. crtableLogoninfo = CrTable.LogOnInfo;
17. crtableLogoninfo.ConnectionInfo = crConnectionInfo;
18. CrTable.ApplyLogOnInfo(crtableLogoninfo);
19.}
20.
21.CrystalReportViewer1.ReportSource = cryRpt;
22.CrystalReportViewer1.RefreshReport();
