一聚教程网:一个值得你收藏的教程网站

热门教程

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

时间:2022-07-02 11:29:18 编辑:袖梨 来源:一聚教程网

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;

热门栏目