linq

VEERENDRA kUMAR

10y1.1kLINQ

Hi,

i have one object it containd Empdata.

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

VEERENDRA kUMAR10y ago
but only using Linq. i know in jquery but i don't want. Request is it poosible or not
0
Nanddeep Nachan10y ago
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
0
VEERENDRA kUMAR10y ago
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.
0
Arul R10y ago
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
0
Nanddeep Nachan10y ago
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) );
0
Manas Mohapatra10y ago
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/
0