private ArrayList rfqList; //All RFQs //CONSTRUCTOR public RFQ_MainScreen() { InitializeComponent(); sql = new MySQLDatabaseDriver(); rfqList = new ArrayList(); //---ADJUST DATAGRIDVIEW APPEARANCE //Center column headings dgvRFQ.Columns["RequestDate"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvRFQ.Columns["RFQNo"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //Center column cell contents dgvRFQ.Columns["RFQNo"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvRFQ.Columns["RequestDate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //---STREAM READER sql.SelectAllRFQDGV(dgvRFQ); //Populate DGV sql.SelectAllRFQ(rfqList); //Sort datagridview by LATEST RFQ Number (Note: When you add an RFQ, it should appear at the top of the DGV) dgvRFQ.Sort(dgvRFQ.Columns["RFQNo"], ListSortDirection.Descending); //Default selected row is the first row if (dgvRFQ.Rows.Count != 0) { dgvRFQ.Rows[0].Selected = true; } }
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. dgvRFQ.Rows.Clear(); sql.SelectAllRFQDGV(dgvRFQ); //Populate DGV //Sort datagridview by LATEST RFQ Number dgvRFQ.Sort(dgvRFQ.Columns["RFQNo"], ListSortDirection.Descending); txtSearch.Text = "Search for..."; cbbFilterBy.SelectedIndex = 0; //Sets the combobox value to "Filter by..." }
public PQ_CreateFromRFQForm() { InitializeComponent(); sql = new MySQLDatabaseDriver(); pqList = new ArrayList(); rfqList = new ArrayList(); selectedRFQList = new ArrayList(); sql.SelectAllRFQDGV(dgvRFQSelection); sql.SelectAllRFQ(rfqList); }