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);
}