C#访问数据库资源库(支持Access、MSSql、MySql、Oracle等)让数据库访问更便捷,更稳定

时间:2013-09-30 10:49:17
【文件属性】:

文件名称: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

网友评论

  • 还行,可以用
  • 多数据库链接 可惜没有源码。。。
  • 多数据库链接 可惜没有源码。。。
  • 不错的,值得下载
  • 嗯,这个不错可以
  • 资源很好啊,我用得很方便~谢谢!
  • 有源码就更好了
  • 资源很好,用的时候很方便,不用每次都弄 DB这块。
  • 资源很好啊,我用得很方便~谢谢!
  • 使用方法太麻烦了,后来在找到简单两步走方案,有需要的可以找我要