.net 连接sql数据库（C#）

新建一个网站

前台Default.aspx不用修改

后台cs文件代码如下：

 

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
    private string myConnectionString=ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;

 

    private void Default()
    {
        SqlConnection myConnection = new SqlConnection(myConnectionString);
        try
        {
            myConnection.Open();
            Response.Write("链接状态: \t\t"
                + (myConnection.State == ConnectionState.Open
                ? "链接成功！" : "链接失败！"));
        }
        catch (SqlException sqlex)
        {
            Response.Write(sqlex.Message + "<br/>");
        }
        finally
        {
            myConnection.Close();
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        Default(); Response.End();
    }
}

 

 

在web.config文件中修改connectionStrings

<connectionStrings>
  <add name="SQLCONNECTIONSTRING" connectionString="data Source=20090818-1556（服务器名/机器名）;database=pubs（数据库名） ;  user id=sa; pwd=" providerName="System.Data.SqlClient"/>
 </connectionStrings>

 

 

注意

cs文件和web.config中的 "SQLCONNECTIONSTRING" 一定要相同

新手刚刚学.net ， 高手别见笑哦