private void fillGrid(string str) { try { //clear the gridview if there are any rows grd_editStockEntry.DataSource = null; grd_editStockEntry.Refresh(); DataGridViewButtonColumn col = new DataGridViewButtonColumn(); col.DataPropertyName = "stockEntryId"; col.Name = "stockEntryId"; col.HeaderText = "Stock Entry Id"; grd_editStockEntry.Columns.Add(col); grd_editStockEntry.DataSource = MANAGEDB.getStockDetails(str); grd_editStockEntry.ColumnHeadersDefaultCellStyle.Font = new Font(DataGridView.DefaultFont, FontStyle.Bold); //arrange the gridview grd_editStockEntry.Columns["stockEntryId"].DisplayIndex = 0; grd_editStockEntry.Columns["itemCode"].DisplayIndex = 1; grd_editStockEntry.Columns["itemName"].DisplayIndex = 2; grd_editStockEntry.Columns["quantity"].DisplayIndex = 3; grd_editStockEntry.Columns["remainQuantity"].DisplayIndex = 4; grd_editStockEntry.Columns["misPlacedQty"].DisplayIndex = 5; grd_editStockEntry.Columns["buyingUnitPrice"].DisplayIndex = 6; grd_editStockEntry.Columns["totalValue"].DisplayIndex = 7; grd_editStockEntry.Columns["sellingUnitPrice"].DisplayIndex = 8; grd_editStockEntry.Columns["createDate"].DisplayIndex = 9; //grd_editStockEntry.Columns["updateDate"].DisplayIndex = 10; //grd_editStockEntry.Columns["stockEntryDate"].DisplayIndex = 11; //grd_editStockEntry.Columns["expirationDate"].DisplayIndex = 12; grd_editStockEntry.Columns["dealerName"].DisplayIndex = 10; //change headers grd_editStockEntry.Columns["stockEntryId"].HeaderText = "Stock_Entry_ID"; grd_editStockEntry.Columns["itemCode"].HeaderText = "Item_Code"; grd_editStockEntry.Columns["itemName"].HeaderText = "Item_Name"; grd_editStockEntry.Columns["quantity"].HeaderText = "Qty"; grd_editStockEntry.Columns["remainQuantity"].HeaderText = "Remain_Qty"; grd_editStockEntry.Columns["misPlacedQty"].HeaderText = "MIsplaced_Qty"; grd_editStockEntry.Columns["buyingUnitPrice"].HeaderText = "Unit_Price(Buy)"; grd_editStockEntry.Columns["totalValue"].HeaderText = "Total_Val"; grd_editStockEntry.Columns["sellingUnitPrice"].HeaderText = "Unit_Price(Sell)"; grd_editStockEntry.Columns["createDate"].HeaderText = "Create_Date"; //grd_editStockEntry.Columns["updateDate"].HeaderText = "Update"; //grd_editStockEntry.Columns["stockEntryDate"].HeaderText = "Entry_Date"; //grd_editStockEntry.Columns["expirationDate"].HeaderText = "Expire"; grd_editStockEntry.Columns["dealerName"].HeaderText = "Dealer"; //hide columns grd_editStockEntry.Columns["updateDate"].Visible = false; grd_editStockEntry.Columns["stockEntryDate"].Visible = false; grd_editStockEntry.Columns["expirationDate"].Visible = false; grd_editStockEntry.Columns["itemId"].Visible = false; grd_editStockEntry.Columns["priceAfterDiscount"].Visible = false; grd_editStockEntry.Columns["comment"].Visible = false; grd_editStockEntry.Columns["releaseFlg"].Visible = false; grd_editStockEntry.Columns["dealerId"].Visible = false; } catch (Exception ex) { COM_MESSAGE.exceptionMessage(ex.Message); } }