Web.Config文件写法

Web.Config

    <connectionStrings>

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

    </connectionStrings>

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字符串, 以下实现对数据库的连接操作

        //利用Web.Config比较安全,因为Web.Config不能被下载有查看

        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

         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>");

        }

    }

}