MVC ASP.NET search filter by int

Question

Is it possible to filter view records via a search for a int? It words but a string but when I try any adapt it to draw all records that match an int I get error: DbComparisonExpression requires arguments with comparable types. in reference to the return view.

Controller:

 public ActionResult Index(string sortOrder,string search)
      {
        ViewBag.TimeSortParam = String.IsNullOrEmpty(sortOrder) ? "Time_desc" : "";
        ViewBag.PrioritySortParam = sortOrder == "Priority" ? "Priority_desc" : "";
        var incidents = from s in db.Incidents.Include(i => i.Defect).Include(i =>   i.Operator)
                        select s;

        if (!String.IsNullOrEmpty(search))
        {
            incidents = incidents.Where(s => s.IncidentID.Equals(search));
        }
 return View(incidents.ToList());

View

Find by id: @Html.TextBox("Search")

I can see the problem is I am using a string for but I cant find a solution for int

it is an INT. I've tried afew thing like solutions like Index(string sortOrder,int search) prehaps something like if (search == null) — user3189899
– user3189899, Commented Feb 28, 2014 at 22:46

user3189899 · Accepted Answer · 2014-03-01 13:41:02Z

1

If anyone is interested this worked, although I am not sure its the most efficient way to filter by an int:

public ActionResult Index(string sortOrder, int? search)
    {
        ViewBag.TimeSortParam = String.IsNullOrEmpty(sortOrder) ? "Time_desc" : "";
        ViewBag.PrioritySortParam = sortOrder == "Priority" ? "Priority_desc" : "";
        var incidents = from s in db.Incidents.Include(i => i.Defect).Include(i => i.Operator)
                        select s;
        if (search != null)
        {
            incidents = incidents.Where(s => s.IncidentID == (search));
        }}
 return View(incidents.ToList());

answered Mar 1, 2014 at 13:41

user3189899

1672 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mattman85208 Over a year ago

Sorta works, I get this error: Unable to create a constant value of type 'System.Object'. Only primitive types or enumeration types are supported in this context. on this line: return View(await requests.ToListAsync());

shenku · Accepted Answer · 2014-03-01 00:02:04Z

0

In your statement, change to:

s.IncidentID==Convert.ToInt32(search)

answered Mar 1, 2014 at 0:02

shenku

12.5k14 gold badges67 silver badges126 bronze badges

1 Comment

user3189899 Over a year ago

got "LINQ to Entities does not recognize the method 'Int32 ToInt32(System.String)' method, and this method cannot be translated into a store expression." @ return View(incidents.ToList());

Collectives™ on Stack Overflow

MVC ASP.NET search filter by int

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related