public DataSet ExecuteProcedureDataSet(HttpServerUtility ServerUtility, string ConnectionStringName, string Procedure, ArrayList paramList, ArrayList returnList)
{
DataSet retrieveSet = new DataSet();
RetrieveUtility retrieveutil = new RetrieveUtility();
string connects = GetConnectionString(ServerUtility, ConnectionStringName);
//retrieveSet = retrieveutil.RetrieveRowsWithParameters(connects, Procedure, paramList, returnList);
return(retrieveSet);
}
public Guid ExecuteProcedureGuid(HttpServerUtility ServerUtility, string ConnectionStringName, string Procedure, ArrayList paramList, string guidName)
{
Guid retrnGuid = Guid.Empty;
RetrieveUtility retrieveutil = new RetrieveUtility();
string connects = GetConnectionString(ServerUtility, ConnectionStringName);
retrnGuid = retrieveutil.RetrieveRowsWithParametersGuid(connects, Procedure, paramList, guidName);
return(retrnGuid);
}
public DataView ExecuteProcedureDataView(HttpServerUtility ServerUtility, string ConnectionStringName, string Procedure, ArrayList paramList)
{
string connects = GetConnectionString(ServerUtility, ConnectionStringName);
RetrieveUtility retrieveutil = new RetrieveUtility();
DataSet retrievData = retrieveutil.RetrieveRowsWithParametersDataSet(connects, Procedure, paramList);
DataView retrievView;
if (retrievData.Tables.Count > 0)
{
retrievView = new DataView(retrievData.Tables[0]);
}
else
{
retrievView = new DataView();
}
return(retrievView);
}
