public Form_AddRoom(List<Room> rooms) { InitializeComponent(); _rooms = rooms; comboBox_TypeRoom.DataSource = WorkWithDatabase.GetAllTypeRooms(); comboBox_typeRadiator.DataSource = WorkWithDatabase.GetAllTypeRadiator(); //материал DataGridViewComboBoxColumn dgwCB = new DataGridViewComboBoxColumn(); dgwCB.ValueMember = "Name"; dgwCB.HeaderText = "Материал"; dgwCB.Width = 200; dgwCB.DataSource = WorkWithDatabase.GetAllMaterials(); dataGridView_wall.Columns.Add(dgwCB); dataGridView_door.Columns.Add((DataGridViewComboBoxColumn)dgwCB.Clone()); dataGridView_floor.Columns.Add((DataGridViewComboBoxColumn)dgwCB.Clone()); dataGridView_ceiling.Columns.Add((DataGridViewComboBoxColumn)dgwCB.Clone()); //стеклопакет DataGridViewComboBoxColumn dgwCB2 = new DataGridViewComboBoxColumn(); dgwCB2.ValueMember = "Name"; dgwCB2.HeaderText = "Стеклопакет"; dgwCB2.Width = 130; dgwCB2.DataSource = WorkWithDatabase.GetAllGlazedes(); dataGridView_windows.Columns.Add(dgwCB2); //площадь профиля DataGridViewTextBoxColumn dgwTB = new DataGridViewTextBoxColumn(); dgwTB.HeaderText = "Профиль (площадь)"; dgwTB.Width = 70; dataGridView_windows.Columns.Add(dgwTB); //количество камер DataGridViewComboBoxColumn dgwCB1 = new DataGridViewComboBoxColumn(); dgwCB1.ValueMember = "CountCameras"; dgwCB1.HeaderText = "Количество камер"; dgwCB1.Width = 70; dgwCB1.DataSource = WorkWithDatabase.GetAllWindowProfilesCountCameras(); dataGridView_windows.Columns.Add(dgwCB1); //толщина DataGridViewComboBoxColumn dgwCB4 = new DataGridViewComboBoxColumn(); dgwCB4.ValueMember = "Thickness"; dgwCB4.HeaderText = "Толщина"; dgwCB4.Width = 70; dgwCB4.DataSource = WorkWithDatabase.GetAllWindowProfilesThickness(); dataGridView_windows.Columns.Add(dgwCB4); }
private void setupDGV() { dgvTM.Columns.Clear(); dgvHM.Columns.Clear(); DataGridViewColumn dgvIndex = new DataGridViewTextBoxColumn(); { dgvIndex.HeaderText = "Index"; dgvIndex.DisplayIndex = 0; dgvIndex.Width = 45; dgvIndex.ReadOnly = true; dgvIndex.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvIndex.SortMode = DataGridViewColumnSortMode.NotSortable; } DataGridViewComboBoxColumn dgvMove = new DataGridViewComboBoxColumn(); { dgvMove.HeaderText = "Move"; dgvMove.DisplayIndex = 1; foreach (string t in movelist) dgvMove.Items.Add(t); // add only the Names dgvMove.Width = 133; dgvMove.FlatStyle = FlatStyle.Flat; dgvIndex.SortMode = DataGridViewColumnSortMode.NotSortable; } dgvTM.Columns.Add(dgvIndex); dgvTM.Columns.Add(dgvMove); dgvHM.Columns.Add((DataGridViewColumn)dgvIndex.Clone()); dgvHM.Columns.Add((DataGridViewColumn)dgvMove.Clone()); }
/* Загрузка данных */ private void TableLoad() { _dataSet.Clear(); _dataSet.DataSetName = "spectacle"; _sqlServer.SelectSqlCommand = "SELECT * FROM spectacle"; _sqlServer.InsertSqlCommand = "INSERT INTO spectacle (spectacle_name, spectacle_genre, spectacle_author, spectacle_director, spectacle_producer, spectacle_designer, spectacle_conductor)" + " VALUES (@spectacle_name, @spectacle_genre, @spectacle_author, @spectacle_director, @spectacle_producer, @spectacle_designer, @spectacle_conductor)"; _sqlServer.InsertParametersAdd("@spectacle_name", SqlDbType.VarChar, 255, "spectacle_name"); _sqlServer.InsertParametersAdd("@spectacle_genre", SqlDbType.VarChar, 50, "spectacle_genre"); _sqlServer.InsertParametersAdd("@spectacle_author", SqlDbType.Int, 11, "spectacle_author"); _sqlServer.InsertParametersAdd("@spectacle_director", SqlDbType.Int, 11, "spectacle_director"); _sqlServer.InsertParametersAdd("@spectacle_producer", SqlDbType.Int, 11, "spectacle_producer"); _sqlServer.InsertParametersAdd("@spectacle_designer", SqlDbType.Int, 11, "spectacle_designer"); _sqlServer.InsertParametersAdd("@spectacle_conductor", SqlDbType.Int, 11, "spectacle_conductor"); _sqlServer.InsertParametersAdd("@spectacle_id", SqlDbType.Int, 11, "spectacle_id"); _sqlServer.UpdateSqlCommand = "UPDATE spectacle SET spectacle_name = @spectacle_name, spectacle_genre = @spectacle_genre, spectacle_author = @spectacle_author, spectacle_director = @spectacle_director, spectacle_producer = @spectacle_producer, spectacle_designer = @spectacle_designer, spectacle_conductor = @spectacle_conductor WHERE (spectacle_id = @spectacle_id)"; _sqlServer.UpdateParametersAdd("@spectacle_name", SqlDbType.VarChar, 255, "spectacle_name"); _sqlServer.UpdateParametersAdd("@spectacle_genre", SqlDbType.VarChar, 50, "spectacle_genre"); _sqlServer.UpdateParametersAdd("@spectacle_author", SqlDbType.Int, 11, "spectacle_author"); _sqlServer.UpdateParametersAdd("@spectacle_director", SqlDbType.Int, 11, "spectacle_director"); _sqlServer.UpdateParametersAdd("@spectacle_producer", SqlDbType.Int, 11, "spectacle_producer"); _sqlServer.UpdateParametersAdd("@spectacle_designer", SqlDbType.Int, 11, "spectacle_designer"); _sqlServer.UpdateParametersAdd("@spectacle_conductor", SqlDbType.Int, 11, "spectacle_conductor"); _sqlServer.UpdateParametersAdd("@spectacle_id", SqlDbType.Int, 11, "spectacle_id"); _sqlServer.DeleteSqlCommand = "DELETE FROM spectacle WHERE (spectacle_id = @spectacle_id)"; _sqlServer.DeleteParametersAdd("@spectacle_id", SqlDbType.Int, 11, "spectacle_id"); if (_sqlServer.ExecuteFill(_dataSet, "spectacle")) { _bindingSource.DataSource = _dataSet; _bindingSource.DataMember = "spectacle"; bindingNavigator1.BindingSource = _bindingSource; dataGridView1.DataSource = _bindingSource; } /* Загрузка списка идентификаторов всех авторов */ DataGridViewComboBoxColumn cBox1 = new DataGridViewComboBoxColumn(); _dataSetAuthor.Clear(); _dataSetAuthor.DataSetName = "author"; _sqlServer2.SelectSqlCommand = "SELECT * FROM author"; if (_sqlServer2.ExecuteFill(_dataSetAuthor, "author")) { foreach (DataRow row in _dataSetAuthor.Tables["author"].Rows) { cBox1.Items.Add(row["author_id"]); } } cBox1.HeaderText = "Автор ID"; cBox1.DataPropertyName = "spectacle_author"; cBox1.Width = 150; dataGridView1.Columns.Add(cBox1); /* Загрузка списка идентификаторов всех работников театра */ DataGridViewComboBoxColumn cBox2 = new DataGridViewComboBoxColumn(); _dataSetStaff.Clear(); _dataSetStaff.DataSetName = "employee"; _sqlServer2.SelectSqlCommand = "SELECT * FROM employee"; if (_sqlServer2.ExecuteFill(_dataSetStaff, "employee")) { foreach (DataRow row in _dataSetStaff.Tables["employee"].Rows) { cBox2.Items.Add(row["employee_id"]); } } cBox2.HeaderText = "Постановщик ID"; cBox2.DataPropertyName = "spectacle_director"; cBox2.Width = 150; dataGridView1.Columns.Add(cBox2); DataGridViewComboBoxColumn cBox3 = new DataGridViewComboBoxColumn(); cBox3 = (DataGridViewComboBoxColumn)cBox2.Clone(); cBox3.HeaderText = "Режиссер-постановщик ID"; cBox3.DataPropertyName = "spectacle_producer"; cBox3.Width = 150; dataGridView1.Columns.Add(cBox3); DataGridViewComboBoxColumn cBox4 = new DataGridViewComboBoxColumn(); cBox4 = (DataGridViewComboBoxColumn)cBox2.Clone(); cBox4.HeaderText = "Художник-постановщик ID"; cBox4.DataPropertyName = "spectacle_designer"; cBox4.Width = 150; dataGridView1.Columns.Add(cBox4); DataGridViewComboBoxColumn cBox5 = new DataGridViewComboBoxColumn(); cBox5 = (DataGridViewComboBoxColumn)cBox2.Clone(); cBox5.HeaderText = "Дирижер ID"; cBox5.DataPropertyName = "spectacle_conductor"; cBox5.Width = 150; dataGridView1.Columns.Add(cBox5); }