connectionodbc.aspx.cs

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

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.Odbc;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        OdbcConnection con = new OdbcConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);
        try
        {
            con.Open();
            Response.Write("链接ODBC数据源的状态：" +con.State.ToString() +"<br>");
            Response.Write("连接ODBC数据源的数据源为：" + con.DataSource.ToString() + "<br>");
            Response.Write("链接ODBC数据源的数据库为：" + con.Database.ToString() + "<br>");
            Response.Write("链接ODBC数据源的驱动器为：" + con.Driver.ToString() + "<br>");
            con.Close();
            Response.Write("链接ODBC数据源的状态：" + con.State.ToString());
            Response.End();
        }
        catch(Exception ex)
        {
            Response.Write(ex.Message);
        }
    }
}