public PO_MainScreen() { InitializeComponent(); sql = new MySQLDatabaseDriver(); poList = new ArrayList(); //ADJUST DATAGRIDVIEW COLUMN ALIGNMENT //Center column headers dgvPO.Columns["OrderDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPO.Columns["DeliveryDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPO.Columns["PONumber"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column contents dgvPO.Columns["OrderDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPO.Columns["DeliveryDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvPO.Columns["PONumber"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //TEST CODE (For the purpose of customizing the DGV and checking out its appearance) /*dgvPO.Rows.Add("09/24/2015", "09/30/2015", "Fat Shaolin Jaideite Kiosk", "BPO#1609-018", "Lucid Co."); * dgvPO.Rows.Add("11/30/2015", "12/30/2015", "St. Theresa School of Novaliches", "BPO#1611-002", "Fluora’s Shop"); * dgvPO.Rows.Add("09/30/2015", "10/30/2015", "Basic Co.", "BPO#1609-001", "Cinco Company"); * dgvPO.Rows.Add("08/23/2015", "09/15/2015", "Basic Co.", "BPO#1608-041", "Mayers Balay");*/ sql.SelectAllPODGV(dgvPO); dgvPO.Sort(dgvPO.Columns["PONumber"], ListSortDirection.Descending); //Sort datagridview by LATEST PO Number (Note: When you add a PO, it should appear at the top of the DGV) sql.SelectAllPO(poList); }
private void btnClearSearch_Click(object sender, EventArgs e) { //Minor flaw: If you click ClearSearch multiple times, the dgv gets populated again, even though nothing was searched. Hehe. dgvPO.Rows.Clear(); sql.SelectAllPODGV(dgvPO); //Populate DGV //Sort datagridview by LATEST PO Number dgvPO.Sort(dgvPO.Columns["PONumber"], ListSortDirection.Descending); txtSearch.Text = "Search for..."; cbbFilterBy.SelectedIndex = 0; //Sets the combobox value to "Filter by..." }