c# 直连orcale数据

不多说了，直接上码。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OracleClient;
namespace WH
{
    class OracleCZ    {
        public static string ORAStringec = "server=;uid=;pwd=;data source=";
        public static System.Data.DataTable GetDataec(string sql)
        {

            OracleConnection ORAconn = new OracleConnection(ORAStringec);
            OracleCommand ORAcmd = new OracleCommand(sql, ORAconn);
            OracleDataAdapter ORAoda = new OracleDataAdapter(ORAcmd);
            DataTable ORAdtORA = new DataTable();
            ORAdtORA.Clear();
            try
            {
                ORAconn.Open();
                ORAoda.Fill(ORAdtORA);
                return ORAdtORA;
            }
            finally
            {
                ORAdtORA.Dispose();
                ORAoda.Dispose();
                ORAcmd.Dispose();
                ORAconn.Dispose();
            }
        }

        public static void SaveDataec(string sql)
        {
            OracleConnection ORAconn = new OracleConnection(ORAStringec);
            OracleCommand ORAcmd = new OracleCommand(sql, ORAconn);
            try
            {
                ORAconn.Open();
                ORAcmd.ExecuteNonQuery();
            }
            finally
            {
                ORAcmd.Dispose();
                ORAconn.Close();
                ORAconn.Dispose();
            }
        }
    }
}

使用方法：

DataTable aa = OracleCZ.GetDataec("select t.*, t.rowid from jl_gate t");
          dataGridView1.DataSource =aa.DefaultView ;