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);
            }
        }