ASP.NET数据库连接

Default.aspx.cs

 

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        //将Web.Config数据引用进行来赋值给connStr字符串, 以下实现对数据库的连接操作

        string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["testConnectionString"].ToString();

        SqlConnection myStr = new SqlConnection(connStr);

        /*SqlConnection myStr = new SqlConnection("Data Source=(local);Initial Catalog=test;Integerated Security=True;Persis SecurityInfo=True;UserID=sa;Password=meng1986");

         SqlConnection myStr = new SqlConnection();

         myStr.ConnectionString = ConfigurationManager.ConnectionStrings["testConnectionString"].ToString();*/

        try

        {

            myStr.Open();

            Response.Write("<script language='JavaScript'>alert('连接数据库成功!');</script>");

 

            myStr.Close();

            Label.Text = "数据库已成功关闭";

 

        }

        catch

        {

 

            Response.Write("<script language='JavaScript'>alert('连接数据库失败!');</script>");

        }

 

    }

}

 

 

 

Web.Config

<connectionStrings>

       <add name="testConnectionString" connectionString="Data Source=(local);Initial Catalog=test; User ID =sa; Password=meng1986"/>

</connectionStrings>