C# -- 使用ODBC连接数据库

c# -- 使用odbc连接数据库

    public class odbchelper
    {
        public static string constring1 = "dsn=sqlserverdsn;database=test;uid=user1;pwd=123456;";
        public static string constring2 = "dsn=oracledsn;uid=user1;pwd=123456;";

        public datatable sqlserverexequery(string sql)
        {
            using (odbcconnection con = new odbcconnection(constring1))
            {
                using (odbccommand cmd = new odbccommand(sql, con))
                {
                    using (odbcdataadapter da = new odbcdataadapter(cmd))
                    {
                        datatable dt = new datatable();
                        con.open();
                        da.fill(dt);
                        return dt;
                    }
                }
            }
        }

        public datatable oracleexequery(string sql)
        {
            using (odbcconnection con = new odbcconnection(constring2))
            {
                using (odbccommand cmd = new odbccommand(sql, con))
                {
                    using (odbcdataadapter da = new odbcdataadapter(cmd))
                    {
                        datatable dt = new datatable();
                        con.open();

                        da.fill(dt);
                        return dt;
                    }
                }
            }
        }

    }

odbc dsn配置：