文件名称:C#访问数据库资源库(支持Access、MSSql、MySql、Oracle等)让数据库访问更便捷,更稳定
文件大小:303KB
文件格式:RAR
更新时间:2013-09-30 10:49:17
C# 数据库 Access MSSql MySql
C#访问数据库资源库(支持Access、MSSql、MySql、Oracle等)让数据库访问更便捷,更稳定 如果需要源代码,可通过邮箱cj5260@163.com索取 访问Access数据库方法 UGM.Common.DAL.DB.DBAccessDAL.string getIdentity(OleDbConnection Conn, OleDbTransaction Tran) UGM.Common.DAL.DB.DBAccessDAL.Connect(string DBSource) UGM.Common.DAL.DB.DBAccessDAL.check(OleDbConnection Conn) UGM.Common.DAL.DB.DBAccessDAL.Excute(OleDbConnection Conn, string CommandText) UGM.Common.DAL.DB.DBAccessDAL.convetAccess(string str) UGM.Common.DAL.DB.DBAccessDAL.Analyse(string FieldType) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string ConnString, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(OleDbConnection Conn, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(OleDbConnection Conn, OleDbTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(ArrayList SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(string ConnString, ArrayList SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string SQLString) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string ConnString, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(string ConnString, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(string SQLString, int start, int max) UGM.Common.DAL.DB.DBAccessDAL.Query(string ConnString, string SQLString, int start, int max) UGM.Common.DAL.DB.DBAccessDAL.Query(OleDbConnection Conn, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(OleDbConnection Conn, OleDbTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string ConnString, string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(Hashtable SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(string ConnString, Hashtable SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string ConnString, string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.ExecuteReader(string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.ExecuteReader(string ConnString, string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.Query(string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.Query(string ConnString, string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.PrepareCommand(OleDbCommand cmd, OleDbConnection conn, string cmdText, OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.PrepareCommand(OleDbCommand cmd, OleDbConnection conn, OleDbTransaction trans, string cmdText, OleDbParameter[] cmdParms) 访问MSSql数据库方法 UGM.Common.DAL.DB.DBMSSqlDAL.string getIdentity(SqlConnection Conn, SqlTransaction Tran) UGM.Common.DAL.DB.DBMSSqlDAL.Connect(string DBSource) UGM.Common.DAL.DB.DBMSSqlDAL.check(SqlConnection Conn) UGM.Common.DAL.DB.DBMSSqlDAL.Excute(SqlConnection Conn, string CommandText) UGM.Common.DAL.DB.DBMSSqlDAL.convetMSSql(string str) UGM.Common.DAL.DB.DBMSSqlDAL.Analyse(string FieldType) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSql(string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSql(string ConnString, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSql(SqlConnection Conn, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSql(SqlConnection Conn, SqlTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSqlTran(ArrayList SQLStringList) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSqlTran(string ConnString, ArrayList SQLStringList) UGM.Common.DAL.DB.DBMSSqlDAL.GetSingle(string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.GetSingle(string ConnString, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.Query(string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.Query(string ConnString, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.Query(string SQLString, int start, int max) UGM.Common.DAL.DB.DBMSSqlDAL.Query(string ConnString, string SQLString, int start, int max) UGM.Common.DAL.DB.DBMSSqlDAL.Query(SqlConnection Conn, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.Query(SqlConnection Conn, SqlTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSql(string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSql(string ConnString, string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSqlTran(Hashtable SQLStringList) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteSqlTran(string ConnString, Hashtable SQLStringList) UGM.Common.DAL.DB.DBMSSqlDAL.GetSingle(string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.GetSingle(string ConnString, string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteReader(string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.ExecuteReader(string ConnString, string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.Query(string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.Query(string ConnString, string SQLString, params SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.PrepareCommand(SqlCommand cmd, SqlConnection conn, string cmdText, SqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMSSqlDAL.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, string cmdText, SqlParameter[] cmdParms) 访问MySql数据库方法 UGM.Common.DAL.DB.DBMySqlDAL.string getIdentity(MySqlConnection Conn, MySqlTransaction Tran) UGM.Common.DAL.DB.DBMySqlDAL.Connect(string DBSource) UGM.Common.DAL.DB.DBMySqlDAL.check(MySqlConnection Conn) UGM.Common.DAL.DB.DBMySqlDAL.Excute(MySqlConnection Conn, string CommandText) UGM.Common.DAL.DB.DBMySqlDAL.convetMySql(string str) UGM.Common.DAL.DB.DBMySqlDAL.Analyse(string FieldType) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSql(string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSql(string ConnString, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSql(MySqlConnection Conn, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSql(MySqlConnection Conn, MySqlTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSqlTran(ArrayList SQLStringList) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSqlTran(string ConnString, ArrayList SQLStringList) UGM.Common.DAL.DB.DBMySqlDAL.GetSingle(string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.GetSingle(string ConnString, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.Query(string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.Query(string ConnString, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.Query(string SQLString, int start, int max) UGM.Common.DAL.DB.DBMySqlDAL.Query(string ConnString, string SQLString, int start, int max) UGM.Common.DAL.DB.DBMySqlDAL.Query(MySqlConnection Conn, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.Query(MySqlConnection Conn, MySqlTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSql(string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSql(string ConnString, string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSqlTran(Hashtable SQLStringList) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteSqlTran(string ConnString, Hashtable SQLStringList) UGM.Common.DAL.DB.DBMySqlDAL.GetSingle(string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.GetSingle(string ConnString, string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteReader(string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.ExecuteReader(string ConnString, string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.Query(string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.Query(string ConnString, string SQLString, params MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.PrepareCommand(MySqlCommand cmd, MySqlConnection conn, string cmdText, MySqlParameter[] cmdParms) UGM.Common.DAL.DB.DBMySqlDAL.PrepareCommand(MySqlCommand cmd, MySqlConnection conn, MySqlTransaction trans, string cmdText, MySqlParameter[] cmdParms) 访问Oracle数据库方法 UGM.Common.DAL.DB.DBOracleDAL.string getIdentity(OracleConnection Conn, OracleTransaction Tran) UGM.Common.DAL.DB.DBOracleDAL.Connect(string DBSource) UGM.Common.DAL.DB.DBOracleDAL.check(OracleConnection Conn) UGM.Common.DAL.DB.DBOracleDAL.Excute(OracleConnection Conn, string CommandText) UGM.Common.DAL.DB.DBOracleDAL.convetOracle(string str) UGM.Common.DAL.DB.DBOracleDAL.Analyse(string FieldType) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSql(string SQLString) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSql(string ConnString, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSql(OracleConnection Conn, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSql(OracleConnection Conn, OracleTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSqlTran(ArrayList SQLStringList) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSqlTran(string ConnString, ArrayList SQLStringList) UGM.Common.DAL.DB.DBOracleDAL.GetSingle(string SQLString) UGM.Common.DAL.DB.DBOracleDAL.GetSingle(string ConnString, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.Query(string SQLString) UGM.Common.DAL.DB.DBOracleDAL.Query(string ConnString, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.Query(string SQLString, int start, int max) UGM.Common.DAL.DB.DBOracleDAL.Query(string ConnString, string SQLString, int start, int max) UGM.Common.DAL.DB.DBOracleDAL.Query(OracleConnection Conn, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.Query(OracleConnection Conn, OracleTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSql(string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSql(string ConnString, string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSqlTran(Hashtable SQLStringList) UGM.Common.DAL.DB.DBOracleDAL.ExecuteSqlTran(string ConnString, Hashtable SQLStringList) UGM.Common.DAL.DB.DBOracleDAL.GetSingle(string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.GetSingle(string ConnString, string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.ExecuteReader(string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.ExecuteReader(string ConnString, string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.Query(string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.Query(string ConnString, string SQLString, params OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.PrepareCommand(OracleCommand cmd, OracleConnection conn, string cmdText, OracleParameter[] cmdParms) UGM.Common.DAL.DB.DBOracleDAL.PrepareCommand(OracleCommand cmd, OracleConnection conn, OracleTransaction trans, string cmdText, OracleParameter[] cmdParms)
【文件预览】:
System.Data.OracleClient.dll
MySql.Data.dll
UGM.Common.DAL.DB.dll