my controller:
[HttpPost]
public ActionResult Search(string SearchKey, string BranchCode)
{
IList<AcctConfirmationPopup> AcctData = null;
AcctData = new List<AcctConfirmationPopup>();
if (SearchKey != null)
{
using (var db = new dbSIEntities())
{
var Acct = from b in db.tblAR
where ((b.BranchCode.ToLower().Contains(BranchCode.ToLower())) && (b.AcctCode.ToLower().Contains(SearchKey.ToLower()) || b.CustName.ToLower().Contains(SearchKey.ToLower())))
select b;
foreach (var accts in Acct)
{
AcctData.Add(new AcctConfirmationPopup() { AcctCode = accts.AcctCode, CustName = accts.CustName, CustAddress = accts.CustAddress });
}
}
}
return PartialView("SearchResults", AcctData.ToList());
}
my Partial view:
<div id="searchResults">
<table id="myDataTable" class="display">
<thead>
<tr>
<th>Account Code</th>
<th>Customer name</th>
<th>Address</th>
</tr>
</thead>
<tbody>
@foreach (var Acct in Model)
{
<tr>
<td>@Acct.AcctCode</td>
<td>@Acct.CustName</td>
<td>@Acct.CustAddress</td>
</tr>
}
</tbody>
</table>
</div>
my view:
@using (Html.BeginForm())
{
<fieldset id="search">
<legend>Search Criteria</legend>
<div>
<div class="searchOption">
@Model.BranchCode
<input id="txtbCode" type="text" value="@Model.BranchCode" style="display:none"/>
</div>
<div class="searchOption">
@Model.BranchName
</div>
</div>
<div>
<div class="searchOption">
<input id="txtSearchkey" type="text" />
</div>
<div class="searchOption">
<input type="hidden" id="StartIndex" value="1" />
<input id="btnSearch" type="button" value="Filter" />
</div>
</div>
</fieldset>
}
<div id="searchResults">
<!-- placeHolder for search results -->
</div>