WinForm中App.config数据库连接问题

[tyco2007]

1.App.config


<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="AppTest" connectionString="Data Source=testsvr;Initial Catalog=test;User ID=sa;password=sa"
providerName="System.Data.SqlClient" />
</connectionStrings>

<applicationSettings>
<TTSFC.Properties.Settings>
<setting name="Company" serializeAs="String">
<value>Xxxxxxxx</value>
</setting>
</TTSFC.Properties.Settings>
</applicationSettings>
<userSettings>
<TTSFC.Properties.Settings>
<setting name="StationNo" serializeAs="String">
<value>01</value>
</setting>
</TTSFC.Properties.Settings>
</userSettings>
</configuration>


2.Code:

using System.Configuration;
....

public string connectionstring =
ConfigurationManager.ConnectionStrings["AppTest*"].ConnectionString.ToString();

public DbProviderFactory provider = DbProviderFactories.GetFactory("System.Data.SqlClient");

...

3.为什么总出错，提示：配置文件未能初始化 错误指向...ConnectionString["Test"].....

[huangmin3956]

好像 App.config 名字不能改吧 只能是Web.Config

[zetee]

<add name="AppTest" connectionString="Data Source=testsvr;Initial Catalog=test;User ID=sa;password=sa"
？
AppTest*"].

？ConnectionString["Test"].....？

[tyco2007]

AppTest*"].是什么？

[threenewbee]

ConfigurationManager.ConnectionStrings["AppTest"].ConnectionString.ToString();

[lanfengsese]

[Quote=引用 4 楼 caozhy 的回复:]
ConfigurationManager.ConnectionStrings["AppTest"].ConnectionString.ToString();
[/Quote]
应该是这个吧

[卧_槽]

你打错字了。

[lanfengsese]

[Quote=引用 1 楼 huangmin3956 的回复:]
好像 App.config 名字不能改吧 只能是Web.Config
[/Quote]
wwinform是App.config

[xiongxyt2]

不能要*
下面是一个实例：
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="家庭理财管理系统.Properties.Settings.familyfinancyConnectionString"
connectionString="Data Source=MICROSOF-33AD20;Initial Catalog=familyfinancy;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="source" value="Server=localhost;Initial Catalog=familyfinancy;Integrated Security=SSPI;" />
</appSettings>
</configuration>


string source = System.Configuration.ConfigurationManager.AppSettings["source"];
SqlConnection conn = new SqlConnection(source);

[xiongxyt2]

不能要*
下面是一个实例：
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="家庭理财管理系统.Properties.Settings.familyfinancyConnectionString"
connectionString="Data Source=MICROSOF-33AD20;Initial Catalog=familyfinancy;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="source" value="Server=localhost;Initial Catalog=familyfinancy;Integrated Security=SSPI;" />
</appSettings>
</configuration>


string source = System.Configuration.ConfigurationManager.AppSettings["source"];
SqlConnection conn = new SqlConnection(source);

[足球中国]

winform估计没有几家公司会用config的。