僅當用戶在同一情況下可用時才會回傳
public async Task<IActionResult> Index(string UserSearch)
{
ViewData["GetUserDDetails"] = UserSearch;
var UserQuery = from x in _context.Users select x;
if (!string.IsNullOrEmpty(UserSearch))
{
UserQuery = UserQuery.Where(x => x.Username.Contains(UserSearch) || x.Email.Contains(UserSearch));
}
return View(await UserQuery.AsNoTracking().ToListAsync());
}
uj5u.com熱心網友回復：
在查詢值和主題值上使用 .ToLower() 或 .ToUpper()。
x => x.Username.ToLower().Contains(UserSearch.ToLower()) || ...
uj5u.com熱心網友回復：
試試這個：
public async Task<IActionResult> Index(string UserSearch)
{
ViewData["GetUserDDetails"] = UserSearch;
var UserQuery = from x in _context.Users select x;
if (!string.IsNullOrEmpty(UserSearch))
{
UserQuery = UserQuery.Where(x => x.Username.ToUpper().Contains(UserSearch.ToUpper()) || x.Email.ToUpper().Contains(UserSearch.ToUpper()));
}
return View(await UserQuery.AsNoTracking().ToListAsync());
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/416899.html
標籤：