配置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();