.net 连接oracle的两种方式

来源：互联网发布：mac 免费画流程图软件编辑：程序博客网时间：2024/05/16 19:55

using System;
using System.Configuration;
using System.Data;
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;
using System.Data.OracleClient;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //OracleClient*******************************************
        String connStr = "Data Source=SRMHIS;User ID=system;Password=manager;";
        OracleConnection conn = new OracleConnection(connStr);
        conn.Open();
        OracleCommand cmd = new OracleCommand();
        cmd = conn.CreateCommand();
        cmd.CommandText = "select * from dept_dict";
        OracleDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {

Response.Write(reader.GetValue(2) + "<br/>");
}

        //oledb**********************************************
        String connStr = "provider=OraOleDb.Oracle;Data Source=SRMHIS;User ID=system;Password=manager";
        OleDbConnection oleconn = new OleDbConnection(connStr);
        oleconn.Open();
        OleDbCommand ocmd = new OleDbCommand();
        ocmd = oleconn.CreateCommand();
        ocmd.CommandText = "select * from dept_dict";
        OleDbDataReader oreader = ocmd.ExecuteReader();
        while (oreader.Read())
        {
            Response.Write(oreader.GetValue(2) + "<br/>");
        }
    }
}