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; } }
public PQ_CreateFromRFQForm() { InitializeComponent(); sql = new MySQLDatabaseDriver(); pqList = new ArrayList(); rfqList = new ArrayList(); selectedRFQList = new ArrayList(); sql.SelectAllRFQDGV(dgvRFQSelection); sql.SelectAllRFQ(rfqList); }