C# 连接Oracle的基础程序

【实例简介】
【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
using System.Data.SqlClient;

namespace OracleTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connStrFormat = "User ID={0};Password={1};Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST ={2})(PORT ={3}))) (CONNECT_DATA = (SERVICE_NAME = {4})))",sqlStrFormat="select * from {0}";
            string strIP = textBox1.Text.Trim(), strPort = textBox2.Text.Trim(), strDb = textBox3.Text.Trim(), strUser = textBox4.Text.Trim(), strPwd = textBox5.Text.Trim(), strTable = textBox6.Text.Trim();
            if (strIP == "" || strPort == "" || strDb == "" || strUser == "" || strTable == "")
            {
                MessageBox.Show("连接信息不能为空，密码除外");
                return;
            }
            using (OracleConnection oconn = new OracleConnection(string.Format(connStrFormat, strUser, strPwd, strIP, strPort, strDb)))
            {
                try
                {
                    oconn.Open();
                    DataSet dst = new DataSet();
                    using (OracleDataAdapter oadp = new OracleDataAdapter(string.Format(sqlStrFormat, strTable), oconn))
                    {
                        oadp.Fill(dst);
                    }
                    if (dst.Tables.Count > 0)
                    {
                        dataGridView1.DataSource = dst.Tables[0];
                    }
                    else
                    {
                        MessageBox.Show("查询失败语法错误");
                    }
                }
                catch(Exception err)
                {
                    MessageBox.Show("查询失败 "   err.Message);
                }
                finally 
                {
                    if (oconn.State == ConnectionState.Open)
                    {
                        oconn.Close();
                    }
                }
            }
            
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)
        {
            string connstr="Data source=.\\sql08;initial catalog=JhxYongdianGL;User ID=sa;password=sa;";
            string sqlstr="select * from openquery(Oracle,'select * from emp')";
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlDataAdapter adp = new SqlDataAdapter(sqlstr,conn))
                {
                    DataSet dst = new DataSet();
                    try
                    {
                        conn.Open();
                        adp.Fill(dst);
                    }
                    catch{}
                    finally
                    {
                        adp.Dispose();
                        conn.Dispose();
                        if (dst.Tables.Count > 0)
                        {
                            dataGridView1.DataSource = dst.Tables[0];
                        }
                        else
                        {
                            dataGridView1.DataSource = new DataTable();
                        }
                    }
                }
            }
        }
    }
}