oracle数据库连接

///宁采花  8:37:39
/// <summary>
        /// 获取数据链接
        /// </summary>
        /// <returns></returns>
        public OracleConnection GetConnection()
        {
            string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            OracleConnection conn = new OracleConnection(str);
            return conn;
        }
public DataTable Get_FFLOWList(string FLTITLE, string FLSORT, int? FLTYPE, string FLDEPID, string FLDEPNAME, string FLAUTHUSER, string FLAUTHDEP, string FLAUTHROLE, int? FLNEEDFORM, int? FID, int? FLSTARTTYPE, int? FLCANUSE, int SIGN, string UORGID, string sort, string isasc, int PageSize, int PageIndex)
        {
            //string sql = get_FFLOWSql(1, FLTITLE,  FLSORT,  FLTYPE,  FLDEPID,  FLDEPNAME,  FLAUTHUSER,  FLAUTHDEP,  FLAUTHROLE,  FLNEEDFORM,  FID,  FLSTARTTYPE,FLCANUSE,  SIGN,UORGID, sort,  isasc,  PageSize,  PageIndex);

            string sql = "select * from rr";
            OracleConnection conn = GetConnection();
            OracleDataAdapter oda = new OracleDataAdapter(sql, conn);
            DataTable dt = new DataTable();
            oda.Fill(dt);
            return dt;
        }
///宁采花  8:46:54
<add name="conn" connectionString="Data Source=JHEAP;User ID=;Password=" providerName="System.Data.OracleClient"/>
///宁采花  8:54:12
<%# DataBinder.Eval(Container.DataItem, "FLINDEX")%>
原文地址:https://www.cnblogs.com/handsomer/p/3678186.html