Hello, I need your help with my program to implement a search function where user can search a list of information from a database using ASP.NET C#. Refer below:

Below are my codes:

products.cshtml

@{ var db = Database.Open("bakery"); var selectQueryString = "SELECT * FROM Product ORDER BY Name";

}

Bakery Products

Search:

@foreach (var row in db.Query(selectQueryString)) { }

Name	Description	Price
@row.Name	@row.Description	@row.Price

----------------------------------------------------------------

Outputs:

Bakery Products Search: apple Name Apple Pie Description Price Second only to your mom's pie 12.99 Bakery Products Search: hello No records found. Bakery Products Search: apple Name Apple Pie Description Price Second only to your mom's pie 12.99 Bakery Products Search: hello No records found