How to use datatable for an ASP.NET Core MVC that consumes a Web API using Stored Procs in SQL?

How to use datatable for an ASP.NET Core MVC that consumes a Web API using Stored Procs in SQL?

krchomekrchome Posts: 1Questions: 1Answers: 0

Hi,
I have an asp.net core 5 web api that communicates to a database in MS-SQL with ADO.Net using stored procs. This api is consumed in another asp.net core MVC project within the same Visual Studio solution.
I wish to use DataTables plug in for the MVC project to accord pagination, sort and filtering functionalities.

Can I get a feedback as to if that's possible with datatables and how to do it (if possible)?

Code: https://github.com/krchome/WebAPICoreMVCClient

Regards,
Kaushik

Answers

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    Hi Kaushik,

    Using stored procedures is not something that the Editor libraries for .NET that we provide can do. However, the client / server specification is fully documented and I'm happy to answer any questions you might have about it. With the information there you would be able to consume the input data and trigger your stored procedures with it, and finally return the JSON data Editor is expecting.

    Regards,
    Allan

Sign In or Register to comment.