急,水晶报表登陆失败问题请教!请大家帮忙,谢谢!
TableLogOnInfo logOnInfo = new TableLogOnInfo ();
string a,b,c,d;
//获取ServerName
a=System.Configuration .ConfigurationSettings.AppSettings["ServerName"];
//获取DatabaseName
b=System.Configuration .ConfigurationSettings .AppSettings ["DatabaseName"];
//获取UserId
c=System.Configuration .ConfigurationSettings .AppSettings ["UserID"];
//获取password
d=System.Configuration .ConfigurationSettings .AppSettings ["Password"];
//设置logOnInfo参数
logOnInfo.ConnectionInfo.ServerName = a;
logOnInfo.ConnectionInfo.DatabaseName = b;
logOnInfo.ConnectionInfo.UserID =c;
logOnInfo.ConnectionInfo.Password =d;
ReportDocument oRpt = new ReportDocument();
string path1;
path1=Server.MapPath ("\\RPSchool\\CrystalReport\\CrystalReport1.rpt");
oRpt.Load (path1);
oRpt.Database.Tables [0].ApplyLogOnInfo (logOnInfo);
SqlConnection myConnection = new SqlConnection(Globals.DBConnectionString);
myConnection.Open ();
DataSet ds =new DataSet ();
int SchoolID=LoginUsers.GetLoggedOnUser().schoolID;
string strSel = "Select * from vSpeciality where SchoolID="+SchoolID+"";
SqlDataAdapter MyAdapter=new SqlDataAdapter (strSel,myConnection);
MyAdapter.Fill(ds,"vSpeciality");
oRpt.SetDataSource(ds);
rptVew.ReportSource =oRpt;
myConnection.Close();