一个数据库连接的问题，提示sa不能登录！！！

[xinghuo8888]

myConnection = new SqlConnection (ConfigurationSettings.AppSettings["edu"]);


上句后面的“edu”　是不是和web.config文件中的下面一句有关？
<appSettings>
　　<add key="edu" value="server=itsigt;uid=sa;pwd=123;database=book_1" />
　　<add key="ViewSourceRoot" value="C:\Inetpub\wwwroot" />

</appSettings>
如果我直接用　
myConnection = new SqlConnection ("server=itsigt;uid=sa;pwd=123;database=book_1");
却可以登录，为什么呢？

请高手指点！

[KentYu]

ConfigurationSettings.AppSettings["edu"].Tostring()

[posemanboy]

晚了 一步

[Deboy_W]

System.Configuration.ConfigurationSettings.AppSettings["edu"]);

不理解，你也不把错误贴出来，怎么给你找啊

[xinghuo8888]

谢谢大家关心！　这是错误信息！
ERROR:System.Data.SqlClient.SqlException: 用户 'sa' 登录失败。 at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ASP.news_aspx.BindGrid() in C:\Inetpub\wwwroot\sample\template\template_03\news.aspx:line 86

[chenhaoying]

看看你要连接的数据库表有sa用户名吗？密码对不对？

[deathbee]

<appSettings>
　　<add key="edu" value="server=itsigt;uid=sa;pwd=123;database=book_1" />
　　<add key="ViewSourceRoot" value="C:\Inetpub\wwwroot" />

</appSettings>

没有关系

[haoztao]

dim str as string =ConfigurationSettings.AppSettings["edu"]
myConnection = new SqlConnection (str)

[liuyu1981831]

不可能
如果myConnection = new SqlConnection ("server=itsigt;uid=sa;pwd=123;database=book_1");
能登录，那么myConnection = new SqlConnection (ConfigurationSettings.AppSettings["edu"]);

<appSettings>
　　<add key="edu" value="server=itsigt;uid=sa;pwd=123;database=book_1" />
</appSettings>
也一定能登录

edu指的就是下面的这个edu

[zdliang]

string Connstr=ConfigurationSettings.AppSettings["edu"];
myConnection = new SqlConnection(Connstr);
试试看，我觉得你的这个问题很奇怪

[slhuang]

确定在WEB.CONFIG里的密码，数据库名，机器名都没写错？
反正就是这么取。 ConfigurationSettings.AppSettings["edu"].ToString();

[zyq1215]

using System.Configuration;

[zzy2740]

ConfigurationSettings.AppSettings["edu"].Tostring()