public DataSet ExecuteDataSet(string spName, ConnectionState connectionstate, params object[] parameterValues) { DbDataAdapter adapter = objFactory.CreateDataAdapter(); DbParameter[] parameters = ParameterCache.GetSpParameterSet(objConnection, spName); AssignParameterValues(parameters, parameterValues); objCommand.Parameters.AddRange(parameters); adapter.SelectCommand = objCommand; DataSet ds = new DataSet(); try { adapter.Fill(ds); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionstate == ConnectionState.CloseOnExit) { if (objConnection.State == System.Data.ConnectionState.Open) { objConnection.Close(); } } } return(ds); }
public object ExecuteScalar(string spName, ConnectionState connectionstate, params object[] parameterValues) { objCommand.CommandText = spName; objCommand.CommandType = CommandType.StoredProcedure; DbParameter[] parameters = ParameterCache.GetSpParameterSet(objConnection, spName); AssignParameterValues(parameters, parameterValues); objCommand.Parameters.AddRange(parameters); object o = null; try { if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } o = objCommand.ExecuteScalar(); } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); if (connectionstate == ConnectionState.CloseOnExit) { objConnection.Close(); } } return(o); }
public DbDataReader ExecuteReader(string spName, ConnectionState connectionstate, params object[] parameterValues) { objCommand.CommandText = spName; objCommand.CommandType = CommandType.StoredProcedure; DbParameter[] parameters = ParameterCache.GetSpParameterSet(objConnection, spName); AssignParameterValues(parameters, parameterValues); objCommand.Parameters.AddRange(parameters); DbDataReader reader = null; try { if (objConnection.State == System.Data.ConnectionState.Closed) { objConnection.Open(); } if (connectionstate == ConnectionState.CloseOnExit) { reader = objCommand.ExecuteReader(CommandBehavior.CloseConnection); } else { reader = objCommand.ExecuteReader(); } } catch (Exception ex) { HandleExceptions(ex); } finally { objCommand.Parameters.Clear(); } return(reader); }