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;
}
}
