protected DataSet ExecuteDataSet(string spName) { try { DataSet recordsDs = new DataSet(); _command = _sqlconnection.CreateCommand(); _command.CommandTimeout = ConnectionTimeout; _command.CommandText = spName; _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddRange(DBParameters.ToArray()); if (_adapter == null) { _adapter = new SqlDataAdapter(); } _adapter.SelectCommand = _command; _adapter.Fill(recordsDs); return(recordsDs); } catch (Exception ex) { throw ex; } }
protected bool SaveData(string spName) { try { if (_sqlconnection == null) { OpenConnection(); } _command = _sqlconnection.CreateCommand(); _command.CommandTimeout = ConnectionTimeout; _command.CommandText = spName; _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddRange(DBParameters.ToArray()); int result = _command.ExecuteNonQuery(); if (result > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
protected IDataReader ExecuteReader(string spName, int read) { try { if (_sqlconnection == null) { OpenConnection(read); } _command = _sqlconnection.CreateCommand(); _command.CommandTimeout = ConnectionTimeout; _command.CommandText = spName; _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddRange(DBParameters.ToArray()); return(_command.ExecuteReader()); } catch (Exception ex) { throw ex; } }