How i can perform search operation in mvc

Samuel Fernandes 1386 24 Aug 2017

Hi friends, I want to perform search operation in mvc application.But i can not do this.
please give me an idea..

Samuel Fernandes

Other

2 Answers

Aryan Kumar 18 Jun 2023

Sure, here is how you can perform search operation in MVC:

Create a model class that represents the data that you want to search.
Create a controller action that gets the data from the model and returns it as a JSON object.
Create a view that renders the search results and passes the JSON object to the view.
Use LINQ to filter the data based on the search criteria.

Here is an example of how you can perform search operation in MVC:

public class ProductModel
{
  public int ProductId { get; set; }
  public string ProductName { get; set; }
  public int QuantitySold { get; set; }
}

public class ProductController : Controller
{
  public ActionResult Search(string searchTerm)
  {
    // Get the products from the database.
    var products = new List<ProductModel>();
    products.Add(new ProductModel { ProductId = 1, ProductName = "Product 1", QuantitySold = 10 });
    products.Add(new ProductModel { ProductId = 2, ProductName = "Product 2", QuantitySold = 20 });
    products.Add(new ProductModel { ProductId = 3, ProductName = "Product 3", QuantitySold = 30 });

    // Filter the products based on the search term.
    var filteredProducts = products.Where(p => p.ProductName.Contains(searchTerm));

    // Return the filtered products as a JSON object.
    return Json(filteredProducts);
  }
}

This code will create a model class that represents the product data. The model class has three properties: ProductId, ProductName, and QuantitySold.

The controller action Search() gets the products from the database and filters the products based on the search term. The search term is passed to the controller action as a parameter.

The view that renders the search results should have a search box that allows the user to enter the search term. The view should also have a list of the products that match the search term.

For example, the following code shows how to render the search results in a view:

HTML

<input type="text" name="searchTerm" />
<button>Search</button>

<ul>
  @foreach (var product in Model) {
    <li>
      <a href="/ProductDetails/{{ product.ProductId }}">
        {{ product.ProductName }}
      </a>
    </li>
  }
</ul>

This code will create a search box that allows the user to enter the search term. The search results will be displayed as a list of links. The links will point to the product details page for each product.

Niraj Kumar Mishra 24 Aug 2017

i don't know what code you want means View or Controller. So i write both code . i hope it will help you.
Controller code:

namespace CompanyDemo.Controllers
{
    public class EmployeeController : Controller
    {
        private SampleDbContext2 db = new SampleDbContext2();

        //
        // GET: /Employee/

        public ActionResult Index(string SearchBy,string Search)
        {
            if (SearchBy == "Name")
            {
                return View(db.Employees.Where(x => x.Name.Contains(Search) || Search == null).ToList());
            }
            else if (SearchBy == "City")
            {
                return View(db.Employees.Where(x => x.City.Contains(Search) || Search == null).ToList());
            }
            else if (SearchBy == "Mobile")
            {
                return View(db.Employees.Where(x => x.Mobile.Contains(Search) || Search == null).ToList());
            }
            else
            {
                var employees = db.Employees.Include(e => e.Company).Include(e => e.EmployeeType);
                return View(employees.ToList());
            }
            
        }
     }
 }

View code:

@model IEnumerable<CompanyDemo.Models.Employee>

@{
    ViewBag.Title = "Index";
}

<div class="container">
    <div class="row">
        <div class="col-md-2" style="margin-left:10px">
          <label>Search By</label>
        </div>
   
     @using (Html.BeginForm("Index", "Employee", FormMethod.Post))
     {        
        <div class="col-md-2">
                   @Html.DropDownList("SearchBy", new List<SelectListItem>
                 { 
                    new SelectListItem{Text="Name", Value="Name", Selected=true},
                    new SelectListItem{Text="City",Value = "City" },
                    new SelectListItem{Text="Mobile",Value = "Mobile" },
                    
                    
                   
                 }, new { @class = "form-control" })

        </div>
        <div class="col-md-2">
         <input type="text" name="search" class="form-control" placeholder="Search..">
        </div>
        <div class="col-md-1">
            <input type="submit" value="Search" class="btn btn-success" />
        </div>
      }     
         
    </div>
</div>

forum

How i can perform search operation in mvc

Can you answer this question?

2 Answers