private void CargarGrid() { try { this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; EArticulos u = new EArticulos(); dataGridView1.DataSource = u.buscar(); dataGridView1.Columns["idArticulos"].Visible = false; this.dataGridView1.Refresh(); tabControl1.SelectedIndex = 0; } catch (Exception ex) { throw ex; } }
private void buscar(string busqueda) { try { EArticulos u = new EArticulos(); dataGridView1.DataSource = u.buscar(busqueda); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.Columns["idArticulos"].Visible = false; tabControl1.SelectedIndex = 0; //ciclo(); } catch (Exception ex) { throw ex; } }
private void cambio() { try { EArticulos c = new EArticulos(); DataTable Clientes = new DataTable(); int id = CmbArticulos.SelectedIndex; Clientes = c.buscar(id); TxtPrecio.Text = Clientes.Rows[id]["precio"].ToString(); nombre = Clientes.Rows[id]["Nombre"].ToString(); } catch (Exception ex) { throw ex; } }
private void LlenarArticulos() { try { EArticulos c = new EArticulos(); DataTable Clientes = new DataTable(); Clientes = c.buscar(); var cb = from ordenar in Clientes.AsEnumerable() select ordenar; CmbArticulos.DataSource = cb.AsDataView(); CmbArticulos.ValueMember = "idArticulos"; CmbArticulos.DisplayMember = "Nombre"; } catch (Exception ex) { throw ex; } }
private Boolean Validad() { if (TxtCantidad.Text != string.Empty) { EArticulos a = new EArticulos(); _ = new DataTable(); DataTable arti = a.buscar(CmbArticulos.SelectedText); int stock = Convert.ToInt32(arti.Rows[0]["stock"].ToString()); int cantidad = Convert.ToInt32(TxtCantidad.Text); string articulo = arti.Rows[0]["Nombre"].ToString(); if (cantidad > stock) { MessageBox.Show("tu maximo de stock para " + articulo + " es de :" + stock.ToString()); } return(true); } else { return(false); } }