We help IT Professionals succeed at work.

How Do You Connect a MVC Application to a Stored Procedure?

danielolorenz
on
I have a C# MVC Web Application that I need to Connect to a Stored Procedure.  I would like to retrieve the results of the stored procedure and put them on a JQuery data grid on a MVC application.

Thanks,

Dan
Comment
Watch Question

Craig WagnerSoftware Architect

Commented:
What have you tried so far and what have the results been? From there we can help you figure out the next steps.
I added the SQL Connection string to the Web.config.  

I made a callback from the search page to a controller and made a call to the stored procedure from the database.

I need to know how to display the data on the MVC search page on a JQuery data table from a DataSet.

Thanks,

Dan

Author

Commented:
Was able to finish that problem.