Searching | Filtering Data in ASP.NET MVC

In this Video, I will teach you how to Search particular data from database using Entity Framework in ASP.NET MVC. The Basic logic behind this task is , first to get all data from database i.e no data filtering but if we have some data into TextBox for filtering then use where clause.

[emanhamid]

amazing !!!! so worth it ! it worked so well!

[sivaanjaneya]

Thanks for give information in filters

[nguyenucthien]

how to Filtering by price??? ex: from 500$ to 1000$??? in entity framework?? please help me?

[Sufferown]

Thanks that's help me a lot, bless!

[meghamisra]

I already have a column name created but my search and filtering in not working when I trying to search created date it not working

public List<CompleteTraining> GetReportTable(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (Test_TrainingEntities db = new Test_TrainingEntities())
{
var v = (from a in db.CompleteTrainings
where
a.FirstName.Contains(search) ||
a.LastName.Contains(search) ||
||
is not accepting search I know it is date time but dont know how to make it serchable?
can you please help me?

everything is working fine if I am not adding created column in search but I want to add this one in my search. And can I change filtering data also? I have added filtering in my grid table but I want to change the display content like it has less than certain etc.. which I want to change like excel.

[ITPogoOnlineTrainings]

I will be right back. You may continue....