直接代码吧:
/// <summary> /// Oracle数据库连接 /// </summary> /// <param name="path">数据库连接串,例如:(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = *)))(CONNECT_DATA =(SERVICE_NAME = *)))</param> /// <param name="user">用户名</param> /// <param name="psw">用户密码</param> /// <returns>Oracle数据库连接对象</returns> private static OracleConnection ConnectOracle(string path, string user, string psw) { OracleConnection oracleConn = new OracleConnection(); string connectionStr = string.Format("Data Source={0};User Id={1};Password={2};", path, user, psw); oracleConn.ConnectionString = connectionStr; return oracleConn; } /// <summary> /// Access数据库连接 /// </summary> /// <param name="path">数据库连接串,例如:@"D:\qingdan.accdb;"</param> /// <param name="flag">Access版本,true为高于2007版</param> /// <returns>Access数据库连接对象</returns> private static OleDbConnection ConnectOracle(string path,bool flag) { OleDbConnection accessConn = null; if (string.IsNullOrWhiteSpace(path) || !File.Exists(path)) { MessageBox.Show("Acess数据库文件不存在", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return accessConn; } string conStr = null; if (flag) { conStr = "Provider=Microsoft.Ace.OleDb.12.0;"; conStr += "Data Source=" + path; conStr += ";Persist Security Info=False;"; } else { conStr = "Provider=Microsoft.Jet.OLEDB.4.0;"; conStr += "Data Source=" + path; } accessConn = new OleDbConnection(conStr); return accessConn; }
以上是建立数据库连接的方法。
对Oracle数据库的查询操作方法如下:
string sqlTest = "";//此处为查询SQL m_dsSet = new DataSet();//查询结果集合 OracleDataAdapter command = new OracleDataAdapter(sqlTest, m_oracleConn); command.Fill(m_dsSet, "ds");
对Access数据库操作:
OleDbCommand dbCommand = new OleDbCommand(); dbCommand.Connection = m_accessConn;//连接串 dbCommand.Transaction = m_accessConn.BeginTransaction(); dbCommand.CommandText ="";//操作命令SQL dbCommand.ExecuteNonQuery(); dbCommand.Transaction.Commit();
转载于:https://blog.51cto.com/hansong007/1368898