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

2022-07-15 80酷酷网 80kuku.com

　　serverReportDocument rptDoc = new ReportDocument();
            rptDoc.Load("x:\\crystalreport\\crPull.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;