连接数据库实例

 

/*  连接数据库实例
    建立一个空白网页Default.aspx，在Default.aspx.cs中添加下面代码*/

 

using System;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    private static String MyconnectionString = "server=**********;database=**********;uid=sa;pwd=**********;";
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            Response.Write("<center><h1>数据库连接实例演示</h1>");
            SqlConnection myConection = new SqlConnection();
            myConection.ConnectionString = MyconnectionString;

            myConection.Open();
            Response.Write("<br><b>数据库连接状态为：" + myConection.State.ToString());

            Response.Write("<br><b>数据库的名称为: " + myConection.Database.ToString());

            Response.Write("<br><b>连接数据库的工作站名：" + myConection.WorkstationId.ToString());

            Response.Write("<br><b>数据库所在服务器名: " + myConection.DataSource.ToString());

            myConection.Close();
            Response.Write("<br><br><b>当前数据库连接状态为：" + myConection.State.ToString()+"</center>");
        }
        catch (Exception ex)
        {
            Response.Write("数据库连接失败: " + ex.Message);
        }

    }
}