User2006925268 posted
Good day. I'm having a problem doing a search in my database. and I've got no idea if I'm doing things correctly. I need help please.
My Database name is Ft_v1
The Table is Events... Tables of Events are (Event_ID, Event_Name, Date, Description, Venue_Name)
The result I'm looking for is how will I be able to display the (Event_ID, Event_Name, Date, Description, Venue_Name) of the search item I've search...
THANK YOU SO MUCH...
@{
var EventSearch = "";
var searchtype = "0";
searchtype = Request["formSearchNo"];
}
<h2>New Specification</h2>
<br />
@{if (IsPost)
{
EventSearch
= "%" + Request["formCustomer"] + "%";
//Print what is in @EventSearch
<text>@EventSearch </text>
//connect to db
var db = Database.Open("Ft_v1");
//compile sql query
var sqlQ = "SELECT * FROM Events where Event_Name like @0";
//execute SQL query
var data = db.Query(sqlQ, EventSearch);
//create grid and display returned sql query data
var grid = new WebGrid(source: data, defaultSort: "name", rowsPerPage: 3);
<text>
@grid.GetHtml(
tableStyle: "grid",
headerStyle: "head",
rowStyle: "row",
columns: grid.Columns(
grid.Column(columnName: "Event_ID", header: "Event Name"),
grid.Column(columnName: "Venue Name", header: "Desc")
)
)
</text>
}
else
{
<form action="" method="post">
<p>EventSearch : <input type="text" name="formEventSearch" /></p>
<p><input type="hidden" name="formSearchNo" value="1" /></p>
<p><input type="submit" value="Search" /></p>
</form> }
if (searchtype == "1")
{
<h3>searched for EventSearch</h3>
}
}
