Ведущий Диалог
Зарегистрирован:
13 December 2004
Сообщения: 177
Примеры кода: 4
|
RE[2]: Login in SQL Server (Crystal Report) |
23 January 2006 09:58 |
|
|
|
|
web.config
<appSettings>
<add key="server" value="RM7" />
<add key="database" value="TFMSys" />
<add key="user" value="RM" />
<add key="password" value="HvAyAg" />
</appSettings>
aspx
protected void Page_Init(object sender, EventArgs e)
{
InitializeComponent();
TableLogOnInfo log = new TableLogOnInfo();
ConnectionInfo ci = new ConnectionInfo();
ci.ServerName = ConfigurationManager.AppSettings["server"];
ci.DatabaseName = ConfigurationManager.AppSettings["database"];
ci.UserID = ConfigurationManager.AppSettings["user"];
ci.Password = ConfigurationManager.AppSettings["password"];
log.ConnectionInfo = ci;
Tables tbs;
CrystalDecisions.CrystalReports.Engine.Table tb;
ReportDocument rDoc = new ReportDocument();
rDoc.Load(Server.MapPath("CrystalReport1.rpt"));
CrystalReportViewer1.ReportSource = rDoc;
tbs = rDoc.Database.Tables;
tb = tbs[0];
log = tb.LogOnInfo;
log.ConnectionInfo = ci;
tb.ApplyLogOnInfo(log);
CrystalReportViewer1.DataBind();
}
ПОПРОБУЙ У МЕНЯ РАБОТАЕТ
Дайте мне точку опоры и я переверну мир
Архимед
|
|