ADO.NET数据库连接代码(调试通过)(OLEDB SQL SERVER ODBC Oracle)

最新推荐文章于 2025-08-06 16:23:50 发布

ITFLY8

最新推荐文章于 2025-08-06 16:23:50 发布

阅读量2.4k

点赞数

分类专栏： ASP.NET 文章标签：数据库 sql server oracle exception string object

ASP.NET 专栏收录该内容

212 篇文章

订阅专栏

本文提供了OleDb、SqlServer、ODBC及Oracle等不同数据库的数据源连接示例代码，并演示了如何在C#中实现这些数据库的连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

OleDb数据源

private void Page_Load(object sender, System.EventArgs e)
  {
      String OleDbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("accessDB.mdb");
   OleDbConnection oleDbConnection = new OleDbConnection(OleDbConnectionString);

   try
   {
    oleDbConnection.Open();
    Response.Write("连接Access数据源成功！！！");
    oleDbConnection.Close();
   }
   catch(Exception ex)
   {
    //抛出数据库连接异常
    Response.Write(ex.Message);
   }
  }

Sql Server数据源

private String SQLConnectionString = "server=qianqian;Database=Northwind;uid=sa;pwd=";
private void InterConnectionSQLServerDB()
{
SqlConnection sqlConnection = new SqlConnection(SQLConnectionString);

   try
   {
    sqlConnection.Open();
    Response.Write("<script>alert('" + sqlConnection.ConnectionString.Replace(";","//n") +"//n数据库的连接成功！！！');</script>");
    sqlConnection.Close();
   }
   catch(Exception ex)
   {
    Response.Write("数据库的连接失败！！！原因如下：<br>" + ex.Message);
   }
  }

ODBC数据源

private String OdbcConnectionString = "DSN=Com991205DB;";

  private void Page_Load(object sender, System.EventArgs e)
  {
   OdbcConnection odbcConnection = new OdbcConnection(OdbcConnectionString);

   try
   {
    odbcConnection.Open();
    //操作数据库
    odbcConnection.Close();
   }
   catch(Exception ex)
   {
    //抛出数据库连接异常
    Response.Write(ex.Message);
   }
  }

Oracle数据源

private String OracleConnectionString = "Data Source=Oracle9i;Integrated Security=yes";
private void ConnectionOracleDB()
  {
   OracleConnection oracleConnection = new OracleConnection(OracleConnectionString);
   try
   {
    oracleConnection.Open();
    Response.Write("<script>alert('" + oracleConnection.ConnectionString.Replace(";","//n") +"//n数据库的连接成功！！！');</script>");
    oracleConnection.Close();
   }
   catch(Exception ex)
   {
    Response.Write("数据库的连接失败！！！原因如下：<br>" + ex.Message);
   }
  }