.net MVC 4 without using entity framework

hi ramesh,

 

This is my source code,bt it won't run,i didn't know where to i mistake,,

 

Don't know that much of MVC,it shows an error records not found.

 

plz can u help

 

This is my controller

 

public ActionResult LoadData()

{

var Items = GetItems("", "", "");

return Json(new { data = Items }, JsonRequestBehavior.AllowGet);

}

private ActionResult GetItems(string PartNo, string Spec, string Desc)

{

try

{

GridWeb getgrid = new GridWeb();

List gtcl = null;

gtcl = getgrid.LoadLargeRecd();

var Items = gtcl;

Items = Items.Where(x => x.Barcode.ToUpper().Contains(PartNo) || x.Manufacturer.ToUpper().Contains(Spec)|| x.ModelNumber.Contains(Desc)).ToList();

ViewBag.Items = Items;

return View(Items);

// Items = (Items

//.Where(x => x.Barcode.Contains(PartNo) && x.Manufacturer.Contains(Spec) && x.ModelNumber.Contains(Desc))).ToList();

}

 

Repository pattern

 

public string _conn = ConfigurationManager.ConnectionStrings["ConnStr"].ToString();

public List LoadLargeRecd()

{

try

{

using (SqlConnection con = new SqlConnection(_conn))

{

con.Open();

string query1 = "select suid,Barcode,Manufacturer,ModelNumber from DataItem";

var res = con.Query(query1);

return res.ToList();

}

}

 

This is my view