解決水晶報表登入錯誤問題

private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此處放置使用者代碼以初始化頁面
   ReportDoc  = new  ReportDocument();
   ReportDoc.Load(Server.MapPath("myReport.rpt"));

      #region 解決登入錯誤問題
   TableLogOnInfo  logonInfo  = new TableLogOnInfo();//
   foreach( CrystalDecisions.CrystalReports.Engine.Table tb in ReportDoc.Database.Tables)
   {
    logonInfo = tb.LogOnInfo;
    logonInfo.ConnectionInfo.ServerName = "(local)";
    logonInfo.ConnectionInfo.DatabaseName = "myDatabase";
    logonInfo.ConnectionInfo.UserID = "sa";
    logonInfo.ConnectionInfo.Password = "";
    tb.ApplyLogOnInfo(logonInfo);
   
   }
   #endregion

   CrystalReportViewer1.ReportSource = ReportDoc;

  }