ASP.NET串連資料庫設定檔

標籤：

// Web.Config<?xml version="1.0" encoding="utf-8"?><!--  有關如何配置 ASP.NET 應用程式的詳細資料，請訪問  http://go.microsoft.com/fwlink/?LinkId=169433  --><configuration>    <system.web>      <compilation debug="false" targetFramework="4.5" />      <httpRuntime targetFramework="4.5" />    </system.web>  <appSettings>    <add key="connectionString" value="server=.;database=stuTest;    uid=sa;pwd=123456"/>  </appSettings></configuration>// 擷取設定檔資訊using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Configuration;public partial class GridViewPage_One : System.Web.UI.Page{    //第一種寫法已經過時，會提示錯誤資訊將ConfigurationSettings改成ConfigurationManager
　　 //然後在命名空間中加入using System.Configuration;    // private string connectionString = ConfigurationSettings.AppSettings["connectionString"].ToString();    private string connectionString = ConfigurationManager.AppSettings["connectionString"].ToString();    protected void Page_Load(object sender, EventArgs e)    {        if (!this.IsPostBack)        {            FillList();        }    }    private void FillList()    {        string selectSql = "select * from Stu";        SqlConnection con = new SqlConnection(connectionString);        SqlCommand cmd = new SqlCommand(selectSql,con);        SqlDataAdapter adapter = new SqlDataAdapter(cmd);        DataSet ds = new DataSet();        try        {            con.Open();            adapter.Fill(ds,"Students");            this.GridView1.DataSource = ds.Tables["Students"].DefaultView;            this.GridView1.DataBind();        }        catch(Exception err)        {            throw err;        }    }}

　　

ASP.NET串連資料庫設定檔