Call Stored Procedure in View ASP.NET MVCAsk Questions

 Posted on 12/07/2018 11:00:49 AM

I've already made a stored procedure and I've called it in Controller, then the next problem is when I called this method below in view class I got error, anyone can help ?

public ListResponse<ViewStoredGraphRow> GetDataGraph()
{
    using (var connection = SqlConnections.NewFor<TryGraphRow>())
    {
       var data = connection.Query<Item>("StoreGraph",
            param: new
            {
                StartDate = 2018 - 07 - 07,
                EndDate = 2018 - 07 - 09
            },
            commandType: System.Data.CommandType.StoredProcedure);

TestPesan tp = new TestPesan();
var response = new ListResponse<ViewStoredGraphRow>(); response.Entities = (List<ViewStoredGraphRow>)data;
return response; } }
Share On: facebook gplus twitter
profile
Asked by ketan Linbachiya on 12/07/2018 11:00:49 AM Score: 269 points
Add Comment:
Submit

Comments

0 Answer

0 Corrected Answers

Post Your Answer

  •  
  •  

Existing Members

Sign in to your account
Email Address
Password
...or Join us
Download, Vote, Comment, Publish.
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.