配置Web.Config連接配接資料庫

 配置Web.Config連接配接資料庫： 

 <appSettings>

   <add key="con" value="server=. 或(local);database=pubs;uid=sa;pwd=;"></add>

 </appSettings> (SQL Server 2000)

 或

 <appSettings/>

 <connectionStrings>

  <add name="city" connectionString="server=jsz49/SQLEXPRESS或server=(local)/SQLEXPRESS或server=./SQLEXPRESS;database=Study_NET;uid=sa;pwd=123456"/>

 </connectionStrings> (SQL Server 2005 SQL Server 身份驗證)

或

  <connectionStrings>

    <add name="MySqlConnection" connectionString="Data Source=./SQLEXPRESS;Initial Catalog=LoginData;Integrated Security=SSPI;"/> (SQL Server 2005 Windows 身份驗證)

  </connectionStrings>

頁面種Page_Load下代碼為：

 SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["con"]);

 con.Open();

 SqlCommand cmd = new SqlCommand("select * from employee", con);

 this.GridView1.DataSource = cmd.ExecuteReader();

 this.GridView1.DataBind();