private void SaveTask() { try { foreach (DataGridViewRow row in dgvTask.Rows) { bool IsChecked = Convert.ToBoolean(row.Cells[5].Value); if (row.Cells[1].Value == DBNull.Value) { row.Cells[1].Value = string.Empty; } } taskAdapter = new tasksTableAdapter(); taskAdapter.Update((tasksDataTable)dgvTask.DataSource); taskAdapter.Dispose(); dgvTask.DataSource = null; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void populateTaskListbox() { try { taskAdapter = new tasksTableAdapter(); tTable = taskAdapter.GetTaskOnActivityIDOrderByInvoiceCode(_passingActivityID); taskAdapter.Dispose(); DataGridViewCellStyle headerStyle = new DataGridViewCellStyle(); headerStyle.Font = new Font(headFont, FontStyle.Bold); dgvTask.RowHeadersVisible = false; dgvTask.AutoGenerateColumns = false; dgvTask.ColumnCount = 5; dgvTask.Columns[0].HeaderText = "Fakturakod"; dgvTask.Columns[0].DataPropertyName = "invoiceCode"; dgvTask.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvTask.Columns[0].HeaderCell.Style = headerStyle; dgvTask.Columns[0].Name = "InvoiceCode"; dgvTask.Columns[1].HeaderText = "Beskrivning"; dgvTask.Columns[1].DataPropertyName = "description"; dgvTask.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dgvTask.Columns[1].HeaderCell.Style = headerStyle; dgvTask.Columns[2].HeaderText = "Budgettimmar"; dgvTask.Columns[2].DataPropertyName = "budgethours"; dgvTask.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvTask.Columns[2].HeaderCell.Style = headerStyle; dgvTask.Columns[3].HeaderText = "Beräknade_timmar"; dgvTask.Columns[3].DataPropertyName = "estimatedHours"; dgvTask.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvTask.Columns[3].HeaderCell.Style = headerStyle; dgvTask.Columns[4].HeaderText = "ActivityID"; dgvTask.Columns[4].DataPropertyName = "activityID"; dgvTask.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvTask.Columns[4].HeaderCell.Style = headerStyle; dgvTask.Columns[4].Visible = false; DataGridViewCheckBoxColumn chkCol = new DataGridViewCheckBoxColumn(); chkCol.HeaderText = "Rubrik"; chkCol.TrueValue = 1; chkCol.FalseValue = 0; chkCol.Name = "chkCol"; chkCol.DataPropertyName = "status"; chkCol.HeaderCell.Style = headerStyle; dgvTask.Columns.Add(chkCol); dgvTask.DataSource = tTable; if (dgvTask.Rows.Count - 1 >= 0) { BeginInvoke((Action)(() => { LoopDgvAndSetStyle(); })); } this.dgvTask.Sort(this.dgvTask.Columns[0], ListSortDirection.Ascending); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }