C# codeusing Oracle.DataAccess.Client;

///

/// Gets some t_points_alm3limitconfigs_new record dynamic for DataSet from the database according to the where and orderby conditions.

///

///

///

///

public DataSet getRecordsDynamicForDS(string whereCondition, string orderByCondition)

{

OracleParameter[] parms = new OracleParameter[3];

if (string.IsNullOrEmpty(whereCondition) == true)

{

whereCondition = string.Empty;

}

if (string.IsNullOrEmpty(orderByCondition) == true)

{

orderByCondition = string.Empty;

}

parms[0] = new OracleParameter("a_WhereCondition", whereCondition);

parms[1] = new OracleParameter("a_OrderByExpression", orderByCondition);

parms[2] = new OracleParameter("c_Result", OracleDbType.RefCursor);

parms[2].Direction = ParameterDirection.Output;

DataSet ds = dal.ExecuteDataSet(CommandType.StoredProcedure, "TPRI.P_PT_ALM3LIMITCONFIG_SW", parms);

return ds;

}