public string m_CustomerCodeSearch(int vrCustomerCode, TextBox vrProductName) { vrProductName.Text = ""; StockTrackingDataContext = new L_StockTrackingERPDataContext(); var CustomerSearch_Query = from albCustomerName in StockTrackingDataContext.p_CustomerSearchAction(vrCustomerCode) select albCustomerName.Column1; foreach (string item in CustomerSearch_Query) { //MessageBox.Show(item); vrLastQuery = item; } return(vrLastQuery); }