Trying to Get Data using Ajax call to Controller method MVC My code Attached

Question

I am calling jquery function on dropdown value change jquery method is ,

function MyFunction() {
    alert($('#DDlSurvey').val());
    $.ajax({
        url: "@Url.Action("GetSelectedQuestion", "ConductSurveyController")",
        data: { prefix: $('#DDlSurvey').val() },
    type: "GET",
    dataType: "json",
    success: function (data) {
        //  loadData(data);
        alert(data)
        alert("Success");
    },
    error: function () {
        alert("Failed! Please try again.");
    }
});
  //$('#YourLabelId').val('ReplaceWithThisValue');
}
</script>

Function I'm calling and I am getting dropdown value alert

Now, Function that I am calling is "GetSelectedQuestion" in controller "ConductSurveyController"

Method is like ,

[HttpPost]
public JsonResult GetSelectedQuestion(int prefix)
{
    List<SelectList> Questions=new List<SelectList>();

   //  Here "MyDatabaseEntities " is dbContext, which is created at time of model creation.
    SurveyAppEntities ObjectSur = new SurveyAppEntities();
       // Questions = ObjectSur.Surveys.Where(a => a.ID.Equals(prefix)).toToList();

I don't think this method is calling as I am getting error

"Failed! Please try again"

From my script.

Hopes for your suggestions

Thanks

 var e = from q in ObjectSur.Questions
         join b in ObjectSur.SurveyQuestions on q.ID equals b.QuestionID where b.SurveyID.Equals(prefix)
         select q ;
         return new JsonResult { Data = e, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}

What http status code is being returned for that request? Check Network tab in Chrome Developer Tools. — mjwills
– mjwills, Commented Nov 28, 2018 at 12:17

Negi Rox · Accepted Answer · 2018-11-28 12:58:25Z

1

I think you are using controller name straight forward. your ajax code be something like this.

var PostData= { prefix: $('#DDlSurvey').val() }
var ajaxOptions = {
        type: "GET",
        url: '@Url.Action("GetSelectedQuestion", "ConductSurvey")',//Actionname, ControllerName
        data: PostData,
        dataType: "json",
        success: function (result) {
            console.log(result);
        },
        error: function (result) {

        }
};
$.ajax(ajaxOptions);

answered Nov 28, 2018 at 12:58

Negi Rox

3,9421 gold badge14 silver badges18 bronze badges

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

3 Comments

john Over a year ago

true man i just finished it with same changes you posted anyways thanks

john Over a year ago

Sorry i misunderstand issue is same as you said but i tried simple method in controller instead one i mentioned in post after making same changes still getting same error perhaps there is error in linq or given method ? how can i check linq

Negi Rox Over a year ago

remove all code and just return simple string message from your MVC controller

Salah Akbari · Accepted Answer · 2018-11-28 13:05:54Z

1

Your method in your controller is decorated with HttpPost, while in your ajax you have specified the type of your request is get . You can either change your method to get like this:

[HttpGet]
public JsonResult GetSelectedQuestion(int prefix)
{
}

Or change your request type to post in your Ajax call:

$.ajax({
    url: "@Url.Action("GetSelectedQuestion", "ConductSurveyController")",
    data: { prefix: $('#DDlSurvey').val() },
    type: "Post",

Also the Controller is redundant in ConductSurveyController, you need to remove it and simply call it as ConductSurvey:

url: '@Url.Action("GetSelectedQuestion", "ConductSurvey")',

edited Nov 28, 2018 at 13:05

answered Nov 28, 2018 at 12:15

Salah Akbari

40k10 gold badges85 silver badges115 bronze badges

Collectives™ on Stack Overflow

Trying to Get Data using Ajax call to Controller method MVC My code Attached

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related