.net MVC 4 without using entity framework

Question

Hi sir How to display large amount of records in grid using server side processing without using entityframework. can u send a sample project sir.

REVATHI R · Answer

hi ramesh This is my source codebt it won't runi didn't know where to i mistake Don't know that much of MVCit 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 suidBarcodeManufacturerModelNumber from DataItem; var res = con.Query (query1); return res.ToList(); } } This is my view $(document).ready(function () { $('#tblItems tfoot th').each(function () { var title = $(this).text(); $(this).html(' '); }); var table = $('#tblItems').DataTable({ ordering: false processing: true serverSide: true lengthMenu: [[100 250 500 -1] [100 250 500 All]] pagingType: full_numbers scrollY: 350px scrollX: true ajax: { url: /DataGrid/LoadData type: GET datatype: json } columns: [ { data: Barcode autoWidth: false } { data: Manufacturer autoWidth: true } { data: ModelNumber autoWidth: true } ] }); model [Display(Name = Barcode)] public string Barcode { get; set; } public string Manufacturer { get; set; } public string ModelNumber { get; set; } //public string Building { get; set; }

Ramesh Palanivel · Answer

Hi Revathi Convert your data set to view model and pass it data table server side.

REVATHI R · Answer

Hi ramesh thank you for ur stuff but I want to display all these records from db conn oriented can u help

Ramesh Palanivel · Answer

Hi Revathi Please refer this below URL http://www.c-sharpcorner.com/article/Asp-Net-mvc5-datatables-plugin-server-side-integration/