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