private void CargarCombos()
{
SubSonic.Select ef = new SubSonic.Select();
ef.From(SysEfector.Schema);
//ef.Where(SysEfector.Columns.IdZona).IsEqualTo(9);
ef.OrderAsc("nombre");
ddlEfector.DataSource = ef.ExecuteTypedList <SysEfector>();
ddlEfector.DataBind();
ddlEfector.Items.Insert(0, new ListItem("TODOS", "0"));
SubSonic.Select e = new SubSonic.Select();
e.From(SysEstado.Schema);
List <SysEstado> estados = e.ExecuteTypedList <SysEstado>();
ddlEstado.DataSource = estados;
ddlEstado.DataBind();
ddlEstado.Items.Insert(0, new ListItem("TODOS", "0"));
SubSonic.Select s = new SubSonic.Select();
s.From(SysSexo.Schema);
List <SysSexo> sexos = s.ExecuteTypedList <SysSexo>();
ddlSexo.DataSource = sexos;
ddlSexo.DataBind();
ddlSexo.Items.Insert(0, new ListItem("TODOS", "0"));
}
