sqlserver.aspx.cs

来自「关于ASP.NET制作程序模块」· CS 代码 · 共 40 行

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)
    {
        //创建连接sql server数据库的对象，并读取web.config文件中连接数据库的字符串
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionsqlserver"].ConnectionString);
        try
        {
            //打开sql server数据库的连接
            con.Open();
            //显示连接成功的信息
            Response.Write("链接sql server数据源的状态：" + con.State.ToString() + "<br>");
            Response.Write("连接sql server数据源的数据源为：" + con.DataSource.ToString() + "<br>");
            Response.Write("链接sql server数据源的数据库为：" + con.Database.ToString() + "<br>");
            Response.Write("链接sql server数据源超时的时间为：" + con.ConnectionTimeout.ToString() + "<br>");
            con.Close();
            Response.Write("链接sql server数据源的状态：" + con.State.ToString());
            //结束response操作对象
            Response.End();
        }
        catch (Exception ex)
        {
            //抛出数据库连接异常
            Response.Write(ex.Message);
        }

    }
}