有什么办法在服务器变动以后不用重新编译程序？

[yaqian82]

正为连接数据库配置文件而发愁。 若连接字串在程序里设定的话,服务器一有变动,程序就得重新编译;又不愿意写进INI文件。有没有什么控件、组件可以简单的实现？

[saucer]

is it webform or winform? in both cases, you can put the connection string in the configuration file, see

<configuration>
<appSettings>
<add key="MyDatabaseConnectionString" value="Provider=Microsoft.Jet,..."/>
<add key="MyExcelFileName" value="C:\...\myWorksheet.xls"/>
</appSettings>
</configuration>


From VB.NET you can read this using:

Dim aConfig As Configuration.ConfigurationSettings
Dim aExcelFile As String = aConfig.AppSettings("MyExcelFileName")


In C# you can write:

using System.Configuration;

string aExcelFile;
aExcelFile = ConfigurationSettings.AppSettings.Get("MyExcelFileName");


see
http://www.thescarms.com/dotNet/AppSettings.asp