public DataSet SelectDetalleAutoridadesSolicitud(ENTAutoridad oENTAutoridad, string sConnectionString)
{
SqlConnection Connection = new SqlConnection(sConnectionString);
SqlCommand Command;
SqlDataAdapter DataAdapter;
SqlParameter Parameter;
DataSet ds = new DataSet();
try
{
Command = new SqlCommand("spSolicitudAutoridadDetalle_sel", Connection);
Command.CommandType = CommandType.StoredProcedure;
Parameter = new SqlParameter("SolicitudId", SqlDbType.Int);
Parameter.Value = oENTAutoridad.SolicitudId;
Command.Parameters.Add(Parameter);
Parameter = new SqlParameter("AutoridadId", SqlDbType.Int);
Parameter.Value = oENTAutoridad.AutoridadId;
Command.Parameters.Add(Parameter);
DataAdapter = new SqlDataAdapter(Command);
Connection.Open();
DataAdapter.Fill(ds);
Connection.Close();
}
catch (SqlException ex)
{
_ErrorId = ex.Number;
_ErrorDescription = ex.Message;
if (Connection.State == ConnectionState.Open) { Connection.Close(); }
}
return ds;
}