//程序名称: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>