private void frmProducto_Load(object sender, EventArgs e) { Lista = TbProductoDAO.SelectAll(); this.TbProductobindingSource.DataSource = Lista; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; }
private void textBox1_TextChanged(object sender, EventArgs e) { //var query = from c in Lista // where c.Descripcion.StartsWith(txtDescripcion.Text) // select c; //this.TbProductobindingSource.DataSource = query; //this.dataGridView1.SelectionMode = // DataGridViewSelectionMode.FullRowSelect; Lista = TbProductoDAO.SelectAll(); ListaCategoria = TbCategoriaDAO.SelectAll(); var ProCat = (from pro in Lista join cat in ListaCategoria on Convert.ToInt32(pro.Categoria) equals cat.CodCategoria select new { pro.CodProducto, pro.Descripcion, pro.Precio, cat.NomCategoria }).ToArray(); var query = (from p in ProCat where p.Descripcion.ToUpper().Trim().Contains(txtDescripcion.Text.ToUpper().Trim()) select new { p.CodProducto, p.Descripcion, p.Precio, p.NomCategoria }).ToArray(); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = query; }
private void frmProducto_Load(object sender, EventArgs e) { //Lista = TbProductoBE.SelectAll(); //Lista = TbProductoDAO.SelectAll(); //this.TbProductobindingSource.DataSource = Lista; //this.dataGridView1.SelectionMode = // DataGridViewSelectionMode.FullRowSelect; Lista = TbProductoDAO.SelectAll(); ListaCategoria = TbCategoriaDAO.SelectAll(); var ProCat = (from pro in Lista join cat in ListaCategoria on Convert.ToInt32(pro.Categoria) equals cat.CodCategoria select new { pro.CodProducto, pro.Descripcion, pro.Precio, cat.NomCategoria }).ToArray(); //this.TbProductobindingSource.DataSource = Lista; this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = ProCat; this.dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; }
public static List <TbProductoBE> SelectAll() { return(TbProductoDAO.SelectAll()); }