protected void ListarOtros() { // read previously chosen items from database con.Open(); SqlCommand cmd = new SqlCommand("uspSEL_LISTAR_RECURSOS_ASIGNADOS", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ID_DETALLE_REQUERIMIENTO_PERSONAL", SqlDbType.Int).Value = Convert.ToInt32(Session["Requerimiento"].ToString()); cmd.Parameters.Add("DES_DESCRIPCION", SqlDbType.VarChar, 100).Value = "OTROS"; cmd.Parameters.Add("DES_TABLA", SqlDbType.VarChar, 100).Value = "ASIGNACION_DETALLE"; SqlDataReader reader = cmd.ExecuteReader(); // iterate through saved entries and add to Hashtable Hashtable savedEntries = new Hashtable(); while (reader.Read()) { string hobbyID = reader["IDE_RECURSO"].ToString(); savedEntries[hobbyID] = true; } con.Close(); // check the corresponding boxes CheckOtros.DataBind(); foreach (ListItem li in CheckOtros.Items) { if (savedEntries.ContainsKey(li.Value)) { li.Selected = true; } } }
protected void Otros() { BL_PERSONAL obj = new BL_PERSONAL(); DataTable dtResultado = new DataTable(); CheckOtros.DataSource = obj.ListarParametros("OTROS", "ASIGNACION_DETALLE"); CheckOtros.DataTextField = "DES_ASUNTO"; CheckOtros.DataValueField = "ID_PARAMETRO"; CheckOtros.DataBind(); }