Searching clients from database table

Hello i have a problem with button search in c#, it is not working (on web application).

here is my code in my controller "ClientController.cs":

public ActionResult GetAllClientDetails(string searchBy, string search)

{

ClientRepository ClientRepo = new ClientRepository();

ModelState.Clear();

if (searchBy == "Numero_compte")

{ return View(ClientRepo.GetAllClients().Where(X => X.Numero_compte == search).ToList()); }

else

{

return View(ClientRepo.GetAllClients().Where(X => X.Nom.StartsWith(search)).ToList());

}

and in my view which i called "GetAllClientDetails.cshtml":

@using (Html.BeginForm("GetAllClientDetails","Client",FormMethod.Get))

{

Serach By : @Html.RadioButton("searchBy", "Numero_compte", true) Numero_compte

@Html.RadioButton("searchBy", "Nom") Nom

@Html.TextBox("Search")

}

I really can't understand what's the problem ... Help please.

2 Replies

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

Zeineb Mhiri9y ago
Sorry .. I didn't understand your idea Sir
Yogendra Bhardwaj9y ago
As per your code you are doing exact match search and it will be case sensative as well. so please try to serach with exact text you have data in table.

If you have client name in your table is Abc Limited and you will search for ABC or Abc as per your code you will not get any results because you should type Abc Limited to get the results becase your code only support exact match