public void getCategoria() { //Variables DataTable dt = new DataTable(); BindingSource bs = new BindingSource(); List <clsCategoria> lstCategoria = new List <clsCategoria>(); clsCategoria objCategoria = new clsCategoria(); //Lenamos el DS de Categorias Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", ""); Data.DataModule.FillDataSet(spCatProductoDS, "spCatCategoria", Params.ToArray()); dt = spCatProductoDS.Tables["spCatCategoria"]; lstCategoria = objCategoria.FillList(dt); bs.DataSource = lstCategoria; this.lueCategoria.Properties.DataSource = bs.List; //this.lueCambiaEstacion.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("EstacionID", "Banco ID")); this.lueCategoria.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Descripcion", "Descripcion")); this.lueCategoria.Properties.DisplayMember = "Descripcion"; this.lueCategoria.Properties.ValueMember = "CategoriaID"; this.lueCategoria.Properties.DropDownRows = lstCategoria.Count; }
public void getCategorias() { //Variables DataTable dt = new DataTable(); BindingSource bs = new BindingSource(); List <clsCategoria> Categoria = new List <clsCategoria>(); clsCategoria c = new clsCategoria(); //Lenamos el DS de Categorias Params.Clear(); Data.DataModule.ParamByName(Params, "Datos", ""); Data.DataModule.FillDataSet(spCatCategoriaDS, "spCatCategoria", Params.ToArray()); dt = spCatCategoriaDS.Tables["spcatCategoria"]; Categoria = c.FillList(dt); bs.DataSource = Categoria; this.lueCategoria.Properties.DataSource = bs.List; this.lueCategoria.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CategoriaID", "Categoria ID")); this.lueCategoria.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Categoria")); this.lueCategoria.Properties.DisplayMember = "Nombre"; this.lueCategoria.Properties.ValueMember = "CategoriaID"; this.lueCategoria.Properties.DropDownRows = Categoria.Count; }