[ASP.net初学者]数据库连接

//Test.aspx.cs页面内容如下,引用项添加System.Configuration的引用。
using System;
using System.Collections.Generic;
using System.Linq;using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace ConnTest{
     public partial class Test : System.Web.UI.Page {
     protected void Page_Load(object sender, EventArgs e)
     {
     if (IsPostBack == false)
        {
             update();
         }
     }
 
     public void update() 
    { string customer = "select * from Names";
     SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connstr"]);
     con.Open(); 
    DataSet ds = new DataSet();
     SqlDataAdapter da = new SqlDataAdapter(customer, con);
     da.Fill(ds,"Customer");
     if (ds != null)
     { gv1.DataSource = ds.Tables[0];
     gv1.DataMember = "Customer";
     gv1.DataBind(); ds.Clear();
     con.Close(); 
    } 
    }
     }
}

//Test.aspx 页面中添加GridView控件，ID为gv1
 //web.config 页面中添加代码如下：
  <appSettings>
    <add key="connstr" value="server=.;Initial Catalog=Test;uid=sa;pwd=sa123456;Max Pool Size = 512;Connect Timeout=600"></add>
  </appSettings>