linq

Question

Hi, i have one object it containd Empdata. like var ob=from emp in dbcontext.employee.tolist(); how to perform search operation. means i am take one textbox . if i am enter any one of the text or character then it shows the relevent row. Example: SEARCH : Ename department Location ------ Abcd X Q1 Bcad A Q1 PQR Z X2 PQR Z Q3 IF i am enter x then dispaly the follwong maaner ENAME depatrment location Abcd X Q1 PQR Z X2 USING linq how to write . condition : now my table contains only 3 filed but in future my table contain 100 fields then how to perform custom search for all fields. please help me

VEERENDRA kUMAR · Answer

but only using Linq. i know in jquery but i don't want. Request is it poosible or not

Nanddeep Nachan · Answer

Bind the employee details to a grid. Use the jQuery to find as you type. See example here: http://www.jquerybyexample.net/2012/04/how-to-search-through-gridview-records.html

VEERENDRA kUMAR · Answer

HI,NANDDEEP thanku for ur answer, your answer is suitable for only 3 fields, my next table conatains 100 fields like ename ,salry ,department,manager................................. 100 fields then how to perform.

Arul R · Answer

Kindly refer the below links, Hope this will solve your problem. http://stackoverflow.com/questions/17952219/how-to-search-through-all-fields-in-a-linq-table http://stackoverflow.com/questions/4153122/how-to-search-in-data-table-using-linq http://stackoverflow.com/questions/21131439/mvc-5-linq-sql-performing-search-from-3-joined-tables http://www.marcusnordquist.com/?p=149 http://stackoverflow.com/questions/17414907/full-text-search-with-linq https://dotnetarchitect.wordpress.com/2009/03/18/using-linq-to-manipulate-data-in-datasetdatatable/ http://stackoverflow.com/questions/12844779/search-on-all-fields-of-an-entity http://stackoverflow.com/questions/17952219/how-to-search-through-all-fields-in-a-linq-table http://www.codeproject.com/Articles/493917/Dynamic-Querying-with-LINQ-to-Entities-and-Express Let me know for any thing more.... If your problem solved means kindly Accept my answer

Nanddeep Nachan · Answer

Please try below code: string searchText = 'Abc'; var ob = from emp in dbcontext.employee.tolist(); ob.Select(x => x.ENAME.contains(searchText) ||x => x.department.contains(searchText) || x => x.location.contains(searchText) );

Manas Mohapatra · Answer

Please go through below links: http://getfishtank.ca/blog/building-dynamic-content-search-linq-queries-in-sitecore-7 http://stackoverflow.com/questions/5539270/linq-dynamic-queries-for-user-search-screens http://www.schiffhauer.com/c-advanced-search-with-reflection-and-dynamic-linq/

linq

Answers (6)