webconfig使用时大小写和dataset填充后发生的问题及解决方案

//程序名称：13-13.aspx.cs
//程序功能：从Web.config中读取数据库连接语句
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _13_13 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //创建Connection对象
        SqlConnection sqlcon = new SqlConnection();
        //创建DataSet对象
        DataSet ds = new DataSet();
        //读取Web.config中的连接语句
        sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings

["xu"].ConnectionString;
        ///这里的["xu"].ConnectionString是对应web.config中的xu" connectionString，

注意，web.config
        ///中的c是小写，而这里的C是大写。

        //连接没有打开的情况下，DataAdapter对象的Fill()方法会自己打开一个连接，使用

后会自动关闭
        SqlDataAdapter sda = new SqlDataAdapter("select * from article", sqlcon);

        Response.Write("没有填充dataset前的sql语句是：" + sqlcon.ConnectionString);
        //向DataSet中加入一个article表
        sda.Fill(ds, "article");
        ///这里的fill一下后，sqlcon.ConnectionString的Password会丢失

        //将GridView1的数据源指定为前边所创建的DataTable
        GridView1.DataSource = ds.Tables["article"];
        //数据绑定
        GridView1.DataBind();
        //输出从Web.config中读取的连接语句
        Response.Write("填充后连接语句为：<br>");
        Response.Write(sqlcon.ConnectionString);

        Response.Write("<br/> 连接字符串为" +

ConfigurationManager.ConnectionStrings["xu"].ConnectionString);
    }
}

<?xml version="1.0"?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    /Windows/Microsoft.Net/Framework/vx.x/Config
-->
<configuration>
 <appSettings/>
 <connectionStrings>
  <add name="xu" connectionString="Data Source=localhost;Initial

Catalog=test;User ID=sa1;Password=sa1" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 <system.web>
  <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
        -->
  <compilation debug="true">
  </compilation>
  <!--
          The <authentication> section enables configuration
          of the security authentication mode used by
          ASP.NET to identify an incoming user.
        -->
  <authentication mode="Windows"/>
  <!--
           The <customErrors> section enables configuration
           of what to do if/when an unhandled error occurs
           during the execution of a request. Specifically,
           it enables developers to configure html error pages
           to be displayed in place of a error stack trace.

           <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
             <error statusCode="403" redirect="NoAccess.htm" />
             <error statusCode="404" redirect="FileNotFound.htm" />
           </customErrors>
        -->
 </system.web>
</configuration>