使用PULL方法的非集成验证(SQL验证) TableLogOnInfo objInfo = new TableLogOnInfo();
ReportDocument objReport = new ReportDocument();
objReport.Load(MapPath("*/*.rpt"));
objInfo.ConnectionInfo.ServerName = @".\sqlexpress";
objInfo.ConnectionInfo.DatabaseName = "数据库名";
objInfo.ConnectionInfo.UserID = "用户名";
objInfo.ConnectionInfo.Password = "密码";
objReport.Database.Tables[0].ApplyLogOnInfo(objInfo); CrystalReportViewer1.ReportSource = objReport;
ReportDocument objReport = new ReportDocument();
objReport.Load(MapPath("*/*.rpt"));
objInfo.ConnectionInfo.ServerName = @".\sqlexpress";
objInfo.ConnectionInfo.DatabaseName = "数据库名";
objInfo.ConnectionInfo.UserID = "用户名";
objInfo.ConnectionInfo.Password = "密码";
objReport.Database.Tables[0].ApplyLogOnInfo(objInfo); CrystalReportViewer1.ReportSource = objReport;
objCon=new SqlConnection("server=.;database=jxcdb;uid=sa;pwd=sa;");
objCon.Open();
objDa=new SqlDataAdapter("select purchaseMaster.purchaseID,productName,purchaseUnitPrice,purchaseQuantity,SubTotal,ValueAddTax,Amount,purchaseDate from purchaseDetail join product on product.productID=purchaseDetail.productID join purchaseMaster on purchaseDetail.purchaseID=purchaseMaster.purchaseID",objCon);
objDs=new DataSet();
objDa.Fill(objDs,"purchase");
purchaseReport.SetDataSource(objDs.Tables["purchase"]);
crystalReportViewer1.ReportSource=purchaseReport;
指的是objReport.Database里的第一个表应用此logoninfo,你把所有的表都应用此logoninfo了吗?可以用个foreach循环