最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
正在研究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;
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;