// GET: LangleyQuery public ActionResult LangleyQuery() { var lets = dbDrive.GetAllLangleyExperimentTables(LangleyPublic.adminId); List <string> productName = new List <string>(); foreach (var let in lets) { if (!productName.Contains(let.let_ProductName)) { productName.Add(let.let_ProductName); } } ViewData["pn"] = productName; return(View()); }