private void txtBuscarMed_KeyPress(object sender, KeyPressEventArgs e) { try { DataSet1TableAdapters.MedicineTableAdapter ta = new DataSet1TableAdapters.MedicineTableAdapter(); DataSet1.MedicineDataTable dt = ta.GetDataByMedicineFiltering(txtBuscarMed.Text//,//string , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text ); // (txtNombre.Text.Trim(), (int)udCantidad.Value, // clnFechaExp.SelectionRange.Start.ToShortDateString(), (decimal)udUnidades.Value, // valorIdSupplier // , (int)idd); ta.FillByMedicineFiltering (dt, txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text , txtBuscarMed.Text ); dataGridView1.DataSource = dt; } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
// private void Refresh() { DataSet1TableAdapters.MedicineTableAdapter ta = new DataSet1TableAdapters.MedicineTableAdapter(); DataSet1.MedicineDataTable dt = ta.GetDataMedicine(); dataGridView1.DataSource = dt; dataGridView1.Columns[0].HeaderText = "Id"; dataGridView1.Columns[1].HeaderText = "Nombre"; dataGridView1.Columns[2].HeaderText = "Caducidad"; dataGridView1.Columns[3].HeaderText = "Cantidad"; dataGridView1.Columns[4].HeaderText = "Presentacion"; dataGridView1.Columns[5].HeaderText = "Unidades"; dataGridView1.Columns[6].HeaderText = "Tipo de Unidades"; dataGridView1.Columns[7].HeaderText = "Cantidad Dosis"; dataGridView1.Columns[8].HeaderText = "Unidades Dosis"; dataGridView1.Columns[9].HeaderText = "Proveedor"; }
private void btnEditar_Click(object sender, EventArgs e) { int?id = GetId(); int valorcillo; // MessageBox.Show(id.ToString()); if (id != null) { DataSet1TableAdapters.MedicineTableAdapter ta = new DataSet1TableAdapters.MedicineTableAdapter(); DataSet1.MedicineDataTable pt = ta.GetDataByIdMedicine((int)id); DataSet1.MedicineRow row = (DataSet1.MedicineRow)pt.Rows[0]; txtNombre.Text = row.MedicineName; udCantidad.Value = row.MedicineQuantity; txtPres.Text = row.MedicineQuantityPres; udUnidades.Value = row.MedicineUnits; // txtTipoUnidad.Text = row.MaterialUnitType; clnFechaExp.SetDate(row.MedicineExpDate); txtTipoUnidad.Text = row.MedicineUnitsType; udUnidadesDosis.Value = row.MedicineDosUnits; udCantidadDosis.Value = row.MedicineDosQuan; valorcillo = row.idSupplier; // MessageBox.Show(valorcillo.ToString()); //from here DataSet1TableAdapters.SupplierTableAdapter tas = new DataSet1TableAdapters.SupplierTableAdapter(); DataSet1.SupplierDataTable pts = tas.GetDataByIdSupplier((int)valorcillo); // DataSet1.SupplierRow rowsup = (DataSet1.SupplierRow)pts.Rows[0]; // txtProveedor.Text = rowsup.ToString(); dgvProveedor.DataSource = pts; } else { MessageBox.Show("No hay registros"); } }