public static Int32 ConnExecute(DBConnType conntype, String connname, String sql) { string ConnStr = ConfigurationManager.ConnectionStrings[connname].ConnectionString; switch (conntype) { case DBConnType.Oledb: OleDbConnection Conn = new OleDbConnection(ConnStr); OleDbCommand cmd = new OleDbCommand(sql, Conn); cmd.Connection.Open(); Int32 rowAffected = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return(rowAffected); case DBConnType.Sql: SqlConnection Conn2 = new SqlConnection(ConnStr); SqlCommand cmd2 = new SqlCommand(sql, Conn2); cmd2.Connection.Open(); Int32 rowAffected2 = cmd2.ExecuteNonQuery(); cmd2.Connection.Close(); return(rowAffected2); default: return(-1); } }
public DataTable ExecuteSQL(string sql, string conn, DBConnType connType) { DataTable table = new DataTable(); switch (connType) { case DBConnType.SQLServer: SqlDataReader reader; using (SqlConnection dbConn = new SqlConnection(conn)) { using (SqlCommand cmd = new SqlCommand(sql, dbConn)) { try { dbConn.Open(); reader = cmd.ExecuteReader(); table.Load(reader); } catch (Exception err) { throw err; } } } break; case DBConnType.Oracle: using (OracleConnection oracleConn = new OracleConnection(conn)) { using (OracleCommand cmd = new OracleCommand(sql, oracleConn)) { //cmd.BindByName = true; //cmd.Parameters.Add(":OrgId", OracleDbType.Varchar2).Value = orgId; //cmd.Parameters.Add(":SDate", OracleDbType.Varchar2).Value = sDate; //cmd.Parameters.Add(":EDate", OracleDbType.Varchar2).Value = eDate; try { oracleConn.Open(); table.Load(cmd.ExecuteReader()); return(table); } catch (Exception err) { throw err; } } } } return(table); }
/// <summary> /// DB連線 /// </summary> /// <param name="dbConnType"></param> /// <returns></returns> public static string getDBConnectionString(DBConnType dbConnType) { return(getDBConnectionString(dbConnType.ToString())); }