using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using Oracle.ManagedDataAccess.Client;
using System.Data;
using System.IO;
using System.Collections;
using System.Diagnostics;
using Oracle.ManagedDataAccess.Types;

namespace OracleDemo
{
  public class OracleHelper
  {
    private static string connStr = "User Id=admin;Password=123;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test)))";

    #region 執(zhí)行SQL語(yǔ)句,返回受影響行數(shù)
    public static int ExecuteNonQuery(string sql, params OracleParameter[] parameters)
    {
      using (OracleConnection conn = new OracleConnection(connStr))
      {
        conn.Open();
        using (OracleCommand cmd = conn.CreateCommand())
        {
          cmd.CommandText = sql;
          cmd.Parameters.AddRange(parameters);
          return cmd.ExecuteNonQuery();
        }
      }
    }
    #endregion
    #region 執(zhí)行SQL語(yǔ)句,返回DataTable;只用來(lái)執(zhí)行查詢(xún)結(jié)果比較少的情況
    public static DataTable ExecuteDataTable(string sql, params OracleParameter[] parameters)
    {
      using (OracleConnection conn = new OracleConnection(connStr))
      {
        conn.Open();
        using (OracleCommand cmd = conn.CreateCommand())
        {
          cmd.CommandText = sql;
          cmd.Parameters.AddRange(parameters);
          OracleDataAdapter adapter = new OracleDataAdapter(cmd);
          DataTable datatable = new DataTable();
          adapter.Fill(datatable);
          return datatable;
        }
      }
    }
    #endregion
  }
}

 string sqlString = "Select a.col1,a.col2 From test a Where a.id=:id";
 DataTable dt = OracleHelper.ExecuteDataTable(sqlString,new OracleParameter(":id",1));