创建setup我的程序,程序运行良好,可以增删改查数据库。
当我打开报告时,总是出现登录提示的问题。但在数据库字段中为空禁用。
在服务器计算机上,报告没有问题。
在我建立连接的代码中,像这样
cnn.ServerName = @"179.15.30.74\SQLEXPRESS";
cnn.DatabaseName = "db_test";
cnn.UserID = "sa";
cnn.Password = "123";
如何禁用登录提示?
[解决了]
我在pc客户端安装sql本机客户端https://www.microsoft.com/en-us/download/details.aspx?id=16978 https://www.microsoft.com/en-us/download/details.aspx?id=16978
您必须设置参数才能报告,如下所示:
ReportDocument cryRpt = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables ;
cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt");
crConnectionInfo.ServerName = "YOUR SERVER NAME";
crConnectionInfo.DatabaseName = "YOUR DATABASE NAME";
crConnectionInfo.UserID = "YOUR DATABASE USERNAME";
crConnectionInfo.Password = "YOUR DATABASE PASSWORD";
CrTables = cryRpt.Database.Tables ;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)