public void ShowLotNumbers() { //Takes Care of Loading the DataGridView with all Active Quotes dgActiveWOR.DataSource = null; Classes.DataAccess.PurchasingDataAccess db = new Classes.DataAccess.PurchasingDataAccess(); activeLotNumbers = db.GetLotNumbers(); dgActiveWOR.DataSource = activeLotNumbers; dgActiveWOR.Columns["LotID"].Visible = false; dgActiveWOR.Columns["OrderQuantity"].Visible = false; dgActiveWOR.Columns["PartDescription"].Visible = false; dgActiveWOR.Columns["JobDueDate"].Visible = false; dgActiveWOR.Columns["MasterDueDate"].Visible = false; dgActiveWOR.Columns["TurnTime"].Visible = false; dgActiveWOR.Columns["Consigned"].Visible = false; dgActiveWOR.Columns["JobComments"].Visible = false; dgActiveWOR.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dgActiveWOR.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; }