CSharp: Connecting to Oracle 11g Database in C#

发布于:2025-02-11 ⋅ 阅读:(102) ⋅ 点赞:(0)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
//using Oracle.DataAccess.Client;
using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Types;
 
namespace WinOracleDemo
{
 
 
    /// <summary>
    /// Oracle.ManagedDataAccess
    /// 4.121.2.0
    /// </summary>
    public partial class Form1 : Form
    {
 
 
        /// <summary>
        ///
        /// </summary>
        public Form1()
        {
            InitializeComponent();
        }
 
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Form1_Load(object sender, EventArgs e)
        {
            OracleConnection conn = null;
            try
            {
                conn = OpenConn();
                var cmd = conn.CreateCommand();
                cmd.CommandText = "select * from DEPT";
                cmd.CommandType = CommandType.Text;
                var reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine(string.Format("No:{0},Name:{1}", reader["DEPTNO"], reader["DNAME"]));
                }
                string sql = "select * from DEPT";
               DataTable dt=OracleHelper.GetTable(sql, CommandType.Text,null);
               this.dataGridView1.DataSource = dt; 
 
 
            }
            catch (OracleException ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                CloseConn(conn);
            }
            Console.Read();
        }
 
 
        static OracleConnection OpenConn()
        {
 
            OracleConnection conn = null;
            try
            {
                conn = new OracleConnection();
                conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));Persist Security Info=True;User ID=SCOTT;Password=888888;";
                conn.Open();
                 
            }
            catch (OracleException ex) {
 
                Console.WriteLine(ex.Message);
            }
            return conn;
        }
 
        static void CloseConn(OracleConnection conn)
        {
            if (conn == null) { return; }
            try
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            catch (OracleException e)
            {
                Console.WriteLine(e.Message);
            }
            finally
            {
                conn.Dispose();
            }
        }
    }
}


网站公告

今日签到

点亮在社区的每一天
去签到