private void FormI_Shown(object sender, EventArgs e)
{
HeaderOfTheTable();
List <RowDB> _data = new List <RowDB>();
DB _manager = new DB();
MySqlCommand _command = new MySqlCommand("SELECT * FROM 'info' ", _manager.GetConnection());
MySqlDataReader _reader;
try
{
_manager.openConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowDB row = new RowDB(_reader["num"], _reader["NumRegion"], _reader["height"], _reader["breast"]);
_data.Add(row);
}
for (int i = 0; i < _data.Count; i++)
{
AddDataGrid(_data[i]);
}
}
catch
{
MessageBox.Show("Ошибка БД!");
}
finally
{
_manager.closeConnection();
}
}
private void buttonChoose_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
_data.Clear();
DB _manager = new DB();
MySqlCommand _command = new MySqlCommand("SELECT * FROM `info`", _manager.GetConnection());
MySqlDataReader _reader;
try
{
_manager.openConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowDB row = new RowDB(_reader["num"], _reader["NumRegion"], _reader["height"], _reader["breast"]);
_data.Add(row);
}
int i = Convert.ToInt32(numericUpDownChoose.Value) - 1;
if (i > 0 && i < _data.Count)
{
AddDataGrid(_data[i]);
}
else
{
MessageBox.Show("Выбран неправильный элемент");
}
}
catch
{
MessageBox.Show("Ошибка!");
}
finally
{
_manager.closeConnection();
}
}
private void загрузитьToolStripMenuItem_Click(object sender, EventArgs e)
{
_data.Clear();
DB _manager = new DB();
MySqlCommand _command = new MySqlCommand("SELECT * FROM `info`", _manager.GetConnection());
MySqlDataReader _reader;
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
try
{
_manager.openConnection();
_reader = _command.ExecuteReader();
while (_reader.Read())
{
RowDB row = new RowDB(_reader["num"], _reader["NumRegion"], _reader["height"], _reader["breast"]);
_data.Add(row);
}
for (int i = 0; i < _data.Count; i++)
{
AddDataGrid(_data[i]);
dataGridView1.Rows[i].Cells[0].ReadOnly = true;
}
}
catch
{
MessageBox.Show("Ошибка!");
}
finally
{
_manager.closeConnection();
}
}
private void AddDataGrid(RowDB row)
{
dataGridView1.Rows.Add(row.num, row.NumRegion, row.height, row.breast);
}
