How to implement datatables in asp.net mvc?

Question

SO I have an entity called product as follow:

public class Product
    {
        [HiddenInput(DisplayValue=false)]
        public int ProductID { get; set; }
        public string ProductName { get; set; }
        [DataType(DataType.MultilineText)]
        public string ProductDescription { get; set; }
        public decimal ProductPrice { get; set; }
        public string Category { get; set; }
        public string SubCategory { get; set; }
    }

I have another class called EFProductRepository which is derived from another class called IProductRepository as following:

public class EFProductRepository : IProductRepository
    {
        private EFDbContext context = new EFDbContext();
        public IEnumerable<Product> Products
        {
            get { return context.Products; }
        }
    }

Then in my controller action Index i have this:

public ViewResult Index()
        {
            return View(repository.Products);
        }

and a view for index which list the data in a table, SO the question is how can i implement the DataTable client side to this piece of code? i tried this here jQuery Datatable with MVC 5 and Entity Framework but no luck unfortunately. Any help is appreciated, Regards.

I assume the datatable plugin expects data in JSON format. convert your context.Products to JSON format ( may be after mapping them to a list of view models which has properties which the plugin is looking for) — Shyju
– Shyju, Commented Apr 12, 2016 at 15:47

Kyle Bachmann · Accepted Answer · 2016-04-12 17:26:41Z

1

If you don't want to convert your object to JSON and mess with all that controller customization, I would suggest checking out this data table that I use in my MVC 5 projects. https://gridmvc.codeplex.com/ This will give you a lot of functionality you may want on the front end anyways, and it just directly binds to a list of objects.

There are easy getting started guides under the documentation.

Good luck

answered Apr 12, 2016 at 17:26

Kyle Bachmann

3263 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Coding Freak Over a year ago

Looks like a good alternative, I can't accept this as answer but i up voted it. I really need to get on DataTables ;)

Collectives™ on Stack Overflow

How to implement datatables in asp.net mvc?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related