public ENTResponse searchcatOcupacion(ENTOcupacion oENTOcupacion, string ConnectionString)
{
SqlConnection sqlCnn = new SqlConnection(ConnectionString);
SqlCommand sqlCom;
SqlParameter sqlPar;
SqlDataAdapter sqlAdapter;
ENTResponse oENTResponse = new ENTResponse();
try
{
sqlCom = new SqlCommand("uspcatOcupacion_Sel", sqlCnn);
sqlCom.CommandType = CommandType.StoredProcedure;
sqlPar = new SqlParameter("OcupacionId", SqlDbType.Int);
sqlPar.Value = oENTOcupacion.OcupacionId;
sqlCom.Parameters.Add(sqlPar);
sqlPar = new SqlParameter("Nombre", SqlDbType.VarChar);
sqlPar.Value = oENTOcupacion.Nombre;
sqlCom.Parameters.Add(sqlPar);
sqlAdapter = new SqlDataAdapter(sqlCom);
oENTResponse.dsResponse = new DataSet();
sqlCnn.Open();
sqlAdapter.Fill(oENTResponse.dsResponse);
sqlCnn.Close();
}
catch (SqlException sqlEX) { oENTResponse.ExceptionRaised(sqlEX.Message); }
catch (Exception ex) { oENTResponse.ExceptionRaised(ex.Message); }
finally {
if (sqlCnn.State == ConnectionState.Open) { sqlCnn.Close(); }
sqlCnn.Dispose();
}
return oENTResponse;
}