If your using a ORM like Entity Framework you can call the list of items in your Controller like this.
//these are the parameters that will pass into a storedprocedure
public ActionResult SearchList()
{
var model = new Models.SearchBy();
model.para1 = 0;
model.para2 = 0;
model.para3 = DateTime.Today;
model.para4 = DateTime.Today;
return View(model);
}
//and then call the list passing the parameters into it the stored procedure
public ActionResult List(Models.SearchBy dr)
{
listEntities n = new listEntities();
var model = n.Get_Gamelist(dr.para1, dr.para2,dr.para3,dr.para4);
return View(model);
}
i hoop this was helpful.