public string m_StockCountTest(int vrProductCode, int vrStoreID) { StockTrackingDataContext = new L_StockTrackingERPDataContext(); var ProductSearch_Query = from albStockCount in StockTrackingDataContext.p_ProductCountSum(vrProductCode, vrStoreID) select albStockCount.Column1; foreach (var item in ProductSearch_Query) { //MessageBox.Show(item); VrProductSumCount = item.ToString(); } return(VrProductSumCount); //StockTrackingDataContext = new L_StockTrackingERPDataContext(); //var Stores_List = from albStores in StockTrackingDataContext.Stocks where (r=>r.) //return Stores_List.ToString(); }