Guest User

Untitled

a guest
Jan 16th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. ReportDocument rpt = new ReportStatement();
  2. TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
  3. TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
  4. ConnectionInfo crConnectionInfo = new ConnectionInfo();
  5. Tables CrTables;
  6. rConnectionInfo.ServerName = "10.10.50.243";
  7. crConnectionInfo.DatabaseName = "StudentDB";
  8. crConnectionInfo.UserID = "DBAdmin";
  9. crConnectionInfo.Password = "abc@123";
  10. CrTables = rpt.Database.Tables;
  11. foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
  12. {
  13. crtableLogoninfo = CrTable.LogOnInfo;
  14. crtableLogoninfo.ConnectionInfo = crConnectionInfo;
  15. crtableLogoninfo.ConnectionInfo.IntegratedSecurity = false;
  16. CrTable.ApplyLogOnInfo(crtableLogoninfo);
  17. }
  18. rpt.SetDatabaseLogon("DBAdmin", "abc@123", "192.168.10.243", "StudentDB");
  19. rpt.SetDataSource(ds);
  20. rpt.Refresh();
  21.  
  22. #endregion
Add Comment
Please, Sign In to add comment