public void listarPaises()
{
using (TIENDASEntities db = new TIENDASEntities())
{
var firstItem = new List<dynamic>()
{
new{ id_Dominio = "T", valor_Dominio = "Todos" }
};
//consulta usando LINQ
var lisPaises = (from p1 in firstItem select p1).Union(from p in db.DOMINIOS
where p.TIPO_DOMINIO.Equals("Paises")
orderby p.VLR_DOMINIO
select new
{
id_Dominio = p.ID_DOMINIO,
valor_Dominio = p.VLR_DOMINIO
});
this.cboPais.DataSource = lisPaises.ToList();
this.cboPais.DisplayMember = "valor_Dominio";
this.cboPais.ValueMember = "id_Dominio";
}
}
/*public void refrescarTabla(){
using (TIENDASEntities db = new TIENDASEntities())
{
var IstFabricantes = from f in db.FABRICANTES select f;
grdDatos.DataSource = IstFabricantes.ToList();
}
}*/
public void refrescarTabla()
{
using (TIENDASEntities db = new TIENDASEntities())
{
var listFabricantes = from f in db.FABRICANTES
select new
{
id_fabricante = f.ID_FABRICANTE,
nombre_fabricante = f.NOM_FABRICANTE,
pais_fabricantes = f.PAIS_FABRICANTE
};
grdDatos.DataSource = listFabricantes.ToList();
}
}
