public string m_ProductCodeSearch(int vrProductCode, TextBox vrProductName)
{
vrProductName.Text = "";
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var ProductSearch_Query = from albStockCount in StockTrackingDataContext.p_ProductSearchAction(vrProductCode) select albStockCount.Column1;
foreach (string item in ProductSearch_Query)
{
//MessageBox.Show(item);
vrLastQuery = item;
}
return(vrLastQuery);
}