private void Data_Shown(object sender, EventArgs e) { HeaderOfTheTable(); List <RowOfData> _data = new List <RowOfData>(); DatabaseManager _manager = new DatabaseManager(); MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection); MySqlDataReader _reader; try { _manager.OpenConnection(); _reader = _command.ExecuteReader(); while (_reader.Read()) { RowOfData row = new RowOfData(_reader["id"], _reader["full_name"], _reader["age"], _reader["sex"], _reader["experience"], _reader["education"], _reader["medical_card"], _reader["car"]); _data.Add(row); } for (int i = 0; i < _data.Count; i++) { AddDataGrid(_data[i]); } } catch { MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг"); } finally { _manager.CloseConnection(); } }
private void обновитьToolStripMenuItem_Click(object sender, EventArgs e) { _data.Clear(); DatabaseManager _manager = new DatabaseManager(); MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection); MySqlDataReader _reader; dataGrid.DataSource = null; dataGrid.Rows.Clear(); try { _manager.OpenConnection(); _reader = _command.ExecuteReader(); while (_reader.Read()) { RowOfData row = new RowOfData( _reader["id"], _reader["full_name"], _reader["age"], _reader["sex"], _reader["experience"], _reader["education"], _reader["medical_card"], _reader["car"]); _data.Add(row); } if (checkBox1.Checked) { dataGrid.ReadOnly = false; } else { dataGrid.ReadOnly = true; } //dobavim v tablicu epta for (int i = 0; i < _data.Count; i++) { AddDataGrid(_data[i]); dataGrid.Rows[i].Cells[0].ReadOnly = true; // id ne trogat suka } } catch { MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг"); } finally { _manager.CloseConnection(); } }
private void AddDataGrid(RowOfData row) { dataGrid.Rows.Add( row.id, row.full_name, row.age, row.sex, row.experience, row.education, row.medical_card, row.car); // dobavlenie strok v tablicu }
private void обновитьToolStripMenuItem_Click(object sender, EventArgs e) { List <RowOfData> _data = new List <RowOfData>(); DatabaseManager _manager = new DatabaseManager(); MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection); MySqlDataReader _reader; //udalyaem tekushie stroki, chtob obnovit dataGrid.DataSource = null; dataGrid.Rows.Clear(); try { _manager.OpenConnection(); _reader = _command.ExecuteReader(); while (_reader.Read()) { RowOfData row = new RowOfData( _reader["id"], _reader["full_name"], _reader["age"], _reader["sex"], _reader["experience"], _reader["education"], _reader["medical_card"], _reader["car"]); _data.Add(row); } for (int i = 0; i < _data.Count; i++) { AddDataGrid(_data[i]); } MessageBox.Show("Данные обновлены!", "Успех"); } catch { MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг"); } finally { _manager.CloseConnection(); } }
private void Choose_Click(object sender, EventArgs e) { dataGrid.DataSource = null; dataGrid.Rows.Clear(); _data.Clear(); DatabaseManager _manager = new DatabaseManager(); MySqlCommand _command = new MySqlCommand("SELECT * FROM `customer`", _manager.GetConnection); MySqlDataReader _reader; try { _manager.OpenConnection(); _reader = _command.ExecuteReader(); while (_reader.Read()) { RowOfData row = new RowOfData(_reader["id"], _reader["full_name"], _reader["age"], _reader["sex"], _reader["experience"], _reader["education"], _reader["medical_card"], _reader["car"]); _data.Add(row); } int i = Convert.ToInt32(numericChoose.Value) - 1; if (i >= 0 && i < _data.Count) { dataGrid.ReadOnly = false; // razreshaem redaktirovac! AddDataGrid(_data[i]); dataGrid.Columns[0].ReadOnly = true; } else { MessageBox.Show("Выбран неправильный элемент!", "Что-то пошло не так!"); } } catch { MessageBox.Show("Произошла ошибка при работе с БД!", "Варнинг"); } finally { _manager.CloseConnection(); } }