public static DataSet getDataSet(string sproc, List <DbParameter> parameters, string sessionID)
        {
            lock (CommonRoutines._lockingObject) {
                DbCommand command = getCommandForSproc(sproc, sessionID);
                if (parameters != null)
                {
                    command.Parameters.AddRange(parameters.ToArray());
                }
                if (useSQLCommandLine())
                {
                    List <DbParameter> parmList = new List <DbParameter>();
                    foreach (DbParameter dbParm in command.Parameters)
                    {
                        parmList.Add(dbParm);
                    }
                    return(executeNonQueryCommandStatement(sproc, parmList, sessionID));
                }
                else
                {
                    if (!SqlServerAllowsSprocs)
                    {
                        StoredProcedureGetDataSet sp = (StoredProcedureGetDataSet)StoredProcedureGetDataSet.buildClassInstance(sproc, parameters);
                        return(sp.getDataSet(sessionID));
                    }
                    else
                    {
                        command.CommandTimeout = 11560;
                        DataAdapter da = getAdapter(command);
                        DataSet     ds = new DataSet();

                        da.Fill(ds);
                        return(ds);
                    }
                }
            }
        }
 public static DataSet getDataSet(string sproc, string selectString, string whereString, string orderByString, string sessionID)
 {
     lock (CommonRoutines._lockingObject) {
         DbCommand   command = getCommandForSproc(sproc, sessionID);
         DbParameter parm    = buildStringParm("SelectClause", selectString, ParameterDirection.Input);
         command.Parameters.Add(parm);
         parm = buildStringParm("WhereClause", whereString, ParameterDirection.Input);
         command.Parameters.Add(parm);
         parm = buildStringParm("OrderByClause", orderByString, ParameterDirection.Input);
         command.Parameters.Add(parm);
         if (useSQLCommandLine())
         {
             List <DbParameter> parmList = new List <DbParameter>();
             foreach (DbParameter dbParm in command.Parameters)
             {
                 parmList.Add(dbParm);
             }
             return(executeNonQueryCommandStatement(sproc, parmList, sessionID));
         }
         else
         {
             if (!SqlServerAllowsSprocs)
             {
                 StoredProcedureGetDataSet sp = StoredProcedureGetDataSet.buildClassInstance(sproc, selectString, whereString, orderByString);
                 return(sp.getDataSet(sessionID));
             }
             else
             {
                 DataAdapter da = getAdapter(command);
                 DataSet     ds = new DataSet();
                 da.Fill(ds);
                 return(ds);
             }
         }
     }
 }