using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace HelloSQL
{
public partial class testConectSQL : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = System.Configuration.
ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString; //在web.config文件设置
using(SqlConnection myconn=new SqlConnection(System.Configuration.
ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString))
{
myconn.Open();
Label2.Text = myconn.State.ToString();
SqlCommand sqlcmd = new SqlCommand("Select 姓名 from student where 学号='3 ' ",myconn);
Label3.Text = sqlcmd.ExecuteScalar().ToString();
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace HelloSQL
{
public partial class testConectSQL : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = System.Configuration.
ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString; //在web.config文件设置
using(SqlConnection myconn=new SqlConnection(System.Configuration.
ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString))
{
myconn.Open();
Label2.Text = myconn.State.ToString();
SqlCommand sqlcmd = new SqlCommand("Select 姓名 from student where 学号='3 ' ",myconn);
Label3.Text = sqlcmd.ExecuteScalar().ToString();
}
}
}
}
//web.config 写入链接数据库的 账户 密码
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="SqlConnStr" connectionString="server=.;uid=abv;pwd=12345678abcdefg;database=stud;" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.5" />
<httpRuntime targetFramework="4.5" />
</system.web>
</configuration>