1. 在控制器中创建适当的动作方法。

public ActionResult Search(string searchTerm)
{
    List customers = new List();
    string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();

        string query = "SELECT * FROM Customers WHERE FirstName LIKE '%' + @searchTerm + '%' OR LastName LIKE '%' + @searchTerm + '%'";
        SqlCommand command = new SqlCommand(query, connection);
        command.Parameters.AddWithValue("@searchTerm", searchTerm);

        SqlDataReader reader = command.ExecuteReader();
        while (reader.Read())
        {
            Customer customer = new Customer();
            customer.Id = (int)reader["Id"];
            customer.FirstName = reader["FirstName"].ToString();
            customer.LastName = reader["LastName"].ToString();
            customer.Email = reader["Email"].ToString();
            customer.Country = reader["Country"].ToString();
            customers.Add(customer);
        }
    }

    return View(customers);
}

2. 在视图中创建适当的搜索表单。

@using (Html.BeginForm("Search", "Customer", FormMethod.Get))
{
    
    Search
}

3. 在视图中创建适当的表格来显示搜索结果。

@if (Model.Count > 0)
{
    
            @foreach (Customer customer in Model)
            {
                
            }
        

        

            

                
First Name
                
Last Name
                
Email
                
Country
            
        
        

                    
@customer.FirstName
                    
@customer.LastName
                    
@customer.Email
                    
@customer.Country
                
    
}
else
{
    
No results found.
}

4. 可能需要创建一个Customer类来存储搜索结果。

public class Customer
{
    public int Id { get; set;