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);
}
