正在研究CrystalReport，下面的代码为当sql server密码不为空时的写法

ReportDocument rptDoc = new ReportDocument();
       rptDoc.Load("x:crystalreportcrPull.rpt");
       
       TableLogOnInfo logOnInfo = new TableLogOnInfo();
       logOnInfo = rptDoc.Database.Tables["tblMagUserInfo"].LogOnInfo;
       ConnectionInfo connectionInfo = new ConnectionInfo();
       connectionInfo = logOnInfo.ConnectionInfo;
       connectionInfo.ServerName = "myserver";
       connectionInfo.DatabaseName = "mydb";
       connectionInfo.UserID = "myid";
       connectionInfo.Password = "mypwd";
       rptDoc.Database.Tables["tblMagUserInfo"].ApplyLogOnInfo(logOnInfo);
       CrystalReportViewer1.ReportSource = rptDoc;