public DataSet GetDataSetFromProcedure(string strSQLWithoutCALLString, iDB2Parameter[] sqlParameters) { var objDataAd = default(iDB2DataAdapter); var objDs = default(DataSet); var objCmd = default(iDB2Command); var objConn = default(iDB2Connection); try { objConn = new iDB2Connection(strConn); objDataAd = new iDB2DataAdapter(); objCmd = new iDB2Command("{CALL " + strSQLWithoutCALLString + "}", objConn); objDataAd.SelectCommand = objCmd; foreach (var objPar in sqlParameters) { objCmd.Parameters.Add(objPar); } objDs = new DataSet(); objDataAd.Fill(objDs); } catch (Exception ex) { if (objCmd is object) { objCmd.Dispose(); } if (objDs is object) { objDs.Dispose(); } objDs = default; objException = ex; } finally { if (objDataAd is object) { objDataAd.Dispose(); } if (objConn is object) { objConn.Close(); objConn.Dispose(); } } return(objDs); }
public DataSet GetDataSet(string strSQL, ref string Err) { var objDs = default(DataSet); var objDataAd = default(iDB2DataAdapter); var dsLocal = new DataSet(); var objConn = default(iDB2Connection); try { objConn = new iDB2Connection(strConn); objConn.Open(); objDs = new DataSet(); objDataAd = new iDB2DataAdapter(strSQL, objConn); objDataAd.Fill(objDs); } catch (Exception ex) { Err = ex.Message; if (dsLocal is object) { dsLocal.Dispose(); } dsLocal = default; objException = ex; } finally { if (objConn is object) { objConn.Close(); objConn.Dispose(); } if (objDataAd is object) { objDataAd.Dispose(); } } return(objDs); }