搜索不适用于MVC中的外键字段 [英] Search not working for foreign key fields in MVC
问题描述
我在我的MVC控制器上实现了搜索。在这里,我无法搜索外键字段。因为它显示Null Reference Exception。请找到代码。
var data =来自db.User.Include中的s(u => u.Role)选择s;
var val = from data in data.AsEnumerable()select r;
if(!String.IsNullOrEmpty(searchString))
{
data = data.Where(s => s.RowNo.ToString()。ToUpper()。包含(searchString.ToUpper())|| s.UserName.ToString()。ToUpper ().Contains(searchString.ToUpper())|| s.RoleID.Role.ToString()。ToUpper()。包含(searchstring.ToUpper()))。OrderBy(x => x.UserID);
}
所以粗体是外国人,我想搜索。但它显示的错误就像NullReference对象。
我在列表视图中显示用户表和RoleTable RoleName的所有数据。所以我有一个搜索框,我可以搜索除外键字段之外的所有字段。
请帮我修复dis。
Hi,
I have implemented a search on my MVC Controller. Here I am not able to search on foreign key fields. As it shows Null Reference Exception. Please find the code.
var data = from s in db.User.Include(u => u.Role) select s;
var val = from r in data.AsEnumerable() select r;
if(!String.IsNullOrEmpty(searchString))
{
data = data.Where(s => s.RowNo.ToString().ToUpper().Contains(searchString.ToUpper()) || s.UserName.ToString().ToUpper().Contains(searchString.ToUpper())|| s.RoleID.Role.ToString().ToUpper().Contains(searchstring.ToUpper())).OrderBy(x => x.UserID);
}
So the bold is foreign that I want to have search. But it is showing error like NullReference object.
I am displaying all the data of user table and RoleTable RoleName on my List View. So I have a search box and I am able 2 search on all fields apart from the Foreign key Field.
Please help me in fixing dis.
推荐答案
这篇关于搜索不适用于MVC中的外键字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!