search-in-Asp-Net-mvc-5-using-ado-net

Question

search a client from a list of clients

Ranjeet Patra · Answer

You can use linq query to find a client from list of clients as below: Client client = clients.Where(c => c.clientId == id); Or you can check with name as well if the name of the clients are distinct.

Zeineb Mhiri · Answer

I forgot to tell you that am working with sql server 2012

Zeineb Mhiri · Answer

Thank you Ranjeet i have another problem if you can help me please  i want to use OrderBy in c# but it doesn't work . My code is : using (LoginDatabaseEntities dc = new LoginDatabaseEntities()) { var clients = dc.Clients.OrderBy(a => a.Numero_compte).ToList(); return Json(new { data = clients } JsonRequestBehavior.AllowGet); } it told me that there is a problem with OrderBy but i don't know what to do ...