private void ZaladujMailDataGridView() { mailDataGridView.DataSource = null; mailDataGridView.Rows.Clear(); mailDataGridView.Columns.Clear(); PokazPrzyciski(false); DataTable pomDataTable = new DataTable(); String result = ""; DBRepository db = new DBRepository(); if (db.SklepyUstawienia_ZaladujMailDatagridView(archiwalneSklepyCB.Checked, archiwalneMaileCB.Checked, ref pomDataTable, ref result)) { if (pomDataTable.Rows.Count > 0) { PokazPrzyciski(true); mailDataGridView.DataSource = pomDataTable; mailDataGridView.Columns["SKL_SklId"].Visible = false; mailDataGridView.Columns["SKL_Nazwa"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; mailDataGridView.Columns["SKL_Archiwalny"].Visible = false; mailDataGridView.Columns["SKM_SkmID"].Visible = false; mailDataGridView.Columns["SKM_SklID"].Visible = false; mailDataGridView.Columns["SKM_Nazwa"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; mailDataGridView.Columns["SKM_Mail"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; mailDataGridView.Columns["SKM_Archiwalny"].Visible = false; mailDataGridView.CurrentCell = mailDataGridView.Rows[0].Cells["SKL_Nazwa"]; } } else { MessageBox.Show("Wystąpił błąd wczytywania listy sklepów:\n" + result, "BŁąd", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ZaladujMailDataGridView() { mailDataGridView.DataSource = null; mailDataGridView.Rows.Clear(); mailDataGridView.Columns.Clear(); delButton.Enabled = false; changeButton.Enabled = false; DBRepository db = new DBRepository(); DataTable pomDataTable = db.SklepyUstawienia_ZaladujMailDatagridView(archiwalneCB.Checked); if (pomDataTable.Rows.Count > 0) { delButton.Enabled = true; changeButton.Enabled = true; mailDataGridView.DataSource = pomDataTable; mailDataGridView.Columns["Sklep_ID"].Visible = false; mailDataGridView.Columns["Sklep_Nazwa"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; mailDataGridView.Columns["Sklep_Email"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; mailDataGridView.Columns["Sklep_CentralaEmail"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; mailDataGridView.Columns["Sklep_Archiwalny"].Visible = false; mailDataGridView.CurrentCell = mailDataGridView.Rows[0].Cells["Sklep_Nazwa"]; } }