protected void FillInventoryGrid() { iProductMasterClient objService = new iProductMasterClient(); try { CustomProfile profile = CustomProfile.GetProfile(); List <SP_GetSiteWiseInventoryByProductIDs_Result> InventoryList = new List <SP_GetSiteWiseInventoryByProductIDs_Result>(); InventoryList = objService.GetInventoryDataByProductIDs(hdnprodID.Value, Session.SessionID, profile.Personal.UserID.ToString(), CurrentObject, profile.DBConnection._constr).ToList(); GVInventory.DataSource = null; GVInventory.DataBind(); GVInventory.DataSource = InventoryList; GVInventory.DataBind(); if (InventoryList.Count > 0) { if (InventoryList[0].EffectiveDate != null) { // UC_EffectiveDateInventory.Date = InventoryList[0].EffectiveDate; } } } catch { } finally { objService.Close(); } }