在C＃中加载Crystal Report时保存登录信息

debugcn 发表于 Dev

猫通维

我创建了一个可以正常运行的Crystal Report，但需要输入登录信息。我在Google上搜索并找到了此代码，但是它对我不起作用。任何有关代码的建议将不胜感激。

private void frmPrintWIPReport_Load(object sender, EventArgs e)
{
    var cryRpt = new ReportDocument();
    var crtableLogoninfo = new TableLogOnInfo();
    var crConnectionInfo = new ConnectionInfo();
    Tables CrTables;

    cryRpt.Load("rptWIP.rpt");

    crConnectionInfo.ServerName = "192.168.40.253";
    crConnectionInfo.DatabaseName = "TNET";
    crConnectionInfo.IntegratedSecurity = true;
    crConnectionInfo.UserID = "sa";
    crConnectionInfo.Password = "******";

    CrTables = cryRpt.Database.Tables;
    foreach (Table CrTable in CrTables)
    {
        crtableLogoninfo = CrTable.LogOnInfo;
        crtableLogoninfo.ConnectionInfo = crConnectionInfo;
        CrTable.ApplyLogOnInfo(crtableLogoninfo);
    }

    crystalReportViewer1.ReportSource = cryRpt;
    crystalReportViewer1.Refresh();
}

库玛·阿基尔（Kumar Akhil）

你可以试试看我希望它与您的需求相同。

private void frmPrintWIPReport_Load(object sender, EventArgs e)
    {
        var cryRpt = new ReportDocument();
        var crtableLogoninfo = new TableLogOnInfo();
        var crConnectionInfo = new ConnectionInfo();
        Tables CrTables;

        cryRpt.Load("rptWIP.rpt");

        ConnectionInfo crConnectionInfo = new ConnectionInfo()
            {
                ServerName = @"192.168.40.253",
                DatabaseName = @"TNET",
                UserID=@"sa",
                Password=@"******"                
               //IntegratedSecurity = true
            };

        CrTables = cryRpt.Database.Tables;
        foreach (Table CrTable in CrTables)
        {
            crtableLogoninfo = CrTable.LogOnInfo;
            crtableLogoninfo.ConnectionInfo = crConnectionInfo;
            CrTable.ApplyLogOnInfo(crtableLogoninfo);
        }

        crystalReportViewer1.ReportSource = cryRpt;
        crystalReportViewer1.Refresh();
    }

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。