private void ListDepartamentos() { RepositorioBase <Departamentos> rep = new RepositorioBase <Departamentos>(); DropDownListDepartamentos.DataSource = rep.GetList(x => true); DropDownListDepartamentos.DataValueField = "IdDepartamento"; DropDownListDepartamentos.DataTextField = "Departamento"; DropDownListDepartamentos.DataBind(); DropDownListDepartamentos.Items.Insert(0, new ListItem("", "")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (SqlConnection conexionDB = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { string query = "select departamento_id, departamento from departamentos"; SqlCommand cmd = new SqlCommand(query); cmd.CommandType = CommandType.Text; cmd.Connection = conexionDB; conexionDB.Open(); SqlDataAdapter adaptador = new SqlDataAdapter(cmd); DataTable tabla = new DataTable(); adaptador.Fill(tabla); DropDownListDepartamentos.DataSource = tabla; DropDownListDepartamentos.DataTextField = "departamento"; DropDownListDepartamentos.DataValueField = "departamento_id"; DropDownListDepartamentos.DataBind(); } using (SqlConnection conexionDB = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { string query = "select categoria_id, categoria from categorias"; SqlCommand cmd = new SqlCommand(query); cmd.CommandType = CommandType.Text; cmd.Connection = conexionDB; conexionDB.Open(); SqlDataAdapter adaptador = new SqlDataAdapter(cmd); DataTable tabla = new DataTable(); adaptador.Fill(tabla); DropDownListCategorias.DataSource = tabla; DropDownListCategorias.DataTextField = "categoria"; DropDownListCategorias.DataValueField = "categoria_id"; DropDownListCategorias.DataBind(); } } }