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

来源：互联网发布：淘宝助理5.4版本下载编辑：程序博客网时间：2024/05/17 23:46

//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>

0 0