private void Refresh()
{
DataSet1TableAdapters.MaterialTableAdapter ta =
new DataSet1TableAdapters.MaterialTableAdapter();
DataSet1.MaterialDataTable dt = ta.GetDataMaterial();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].HeaderText = "Id";
dataGridView1.Columns[1].HeaderText = "Nombre";
dataGridView1.Columns[2].HeaderText = "Cantidad";
dataGridView1.Columns[3].HeaderText = "Presentacion";
dataGridView1.Columns[4].HeaderText = "Unidades";
dataGridView1.Columns[5].HeaderText = "Caducidad";
dataGridView1.Columns[6].HeaderText = "Proveedor";
}
