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配置:
黄山市民网:https://www.huangshanshimin.com/