水晶報表ConnectionInfo問題,請進來看看能否解決﹖

[mrguo]

Dim tb As CrystalDecisions.CrystalReports.Engine.Table
Dim tbl As TableLogOnInfo
For Each tb In mydocrpt.Database.Tables
tbl = tb.LogOnInfo
tbl.ConnectionInfo.DatabaseName = "exam"
tbl.ConnectionInfo.Password = "536124"
tbl.ConnectionInfo.UserID = "sa"
tbl.ConnectionInfo.ServerName = "mrguo"
tb.ApplyLogOnInfo(tbl)
Next
有以上程式﹐現在我想用ConfigurationSettings.AppSettings("ConnectionString")來取代以上的連接信息

[haonanernet]

在page_load里面加入
Dim oRpt As New CrystalReport1
oRpt.SetDataSource(ds.Tables(0))
oRpt.SetDatabaseLogon("sa", "数据库密码", "(localhost)", "你要连接的数据库名称")
CrystalReportViewer1.ReportSource = oRpt

[mrguo]

我的意思希望使用WEB.config里面的﹐這樣修改數據庫﹐就不用動應用程式了

[mrguo]

怎么都沒人來看呀

[lyrixliu]

在web.config里面的appsetting里面保存连接串信息

程序里面用ConfigurationSettings读取出来，解析，赋值

[pgpga]

在web.config里加入
<appSettings>
<add key="ConnectionString" value="Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=DatabaseName;Data Source=(Local)"/>
</appSettings>

[aivii]

<appSettings>
<add key="connStr" value="Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=DatabaseName;Data Source=(Local)"/>
</appSettings>

[mrguo]

我意思是利用樓上﹐如何分別取得user id ﹑password等值

[hxy2003]

UP

[mrguo]

還沒解決到呀

[mrguo]

這么久了還沒人幫一下咩

[smallyear]

web.config:
<appSettings>
<add key="Server" value="SZDEV02"></add>
<add key="Database" value="ACC_DB"></add>
<add key="UserID" value="sa"></add>
<add key="Password" value="sa"></add>
</appSettings>

aspx文件﹕
using System.Configuration;

rpt.SetDatabaseLogon(ConfigurationSettings.AppSettings["UserID"],ConfigurationSettings.AppSettings["Password"],ConfigurationSettings.AppSettings["Server"],ConfigurationSettings.AppSettings["Database"]);

rpt為你報表的實例