code to fetch and return database string data based on dropdown box onchange event through .net controller class to form page using ajax

Question

C#,ASP.NET MVC,Ajax:-I have a form page where there is a drop down list showing customers name from database table customers.Based on the customer selection by passing customer id to database table I want to fetch his email id and contact number and display it in form read only text fields.My problem is controller code is not working.In other words i am not able to check whether id is reaching my controller function to fetch data and the query is executing or not.I am getting error function data on form page

My jquery code is as below

CustomerList1 is the id for drop down box

var cusKey to hold customer id

GetCustmrDetails is my controller function to fetch data based on id

$("#CustomerList1").change(function (event) {
        var cusKey = $("#CustomerList1").val();
        alert("customerKey:" + cusKey);
        $.ajax({
              type: 'GET',
              url: "/CustomerController/GetCustmrDetails/",
              contentType: "application/json; charset=utf-8",
              dataType: "json",
              data: JSON.stringify({ "id": cusKey }),
            success: function (data) {
                alert("available");
                $("#EMailAddress").val(data.EMailAddress);
                $('#Phone').val(data.Phone);
            },
            error: function () {
                alert("error");
            }
        });
    });

My controller code is as below

[HttpGet]
    public ActionResult GetCustmrDetails(int id)
    {

        List<CustomerModel> customer = new List<CustomerModel>();
        string query = string.Format("Select EMailAddress,Phone From 
        OC_Customer where CustomerKey="+id);
        SqlConnection connection = new SqlConnection(connectionString);
        {
            using (SqlCommand cmd = new SqlCommand(query, connection))
            {
                connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    customer.Add(new CustomerModel{
                        EMailAddress = reader["EMailAddress"].ToString(),
                        Phone = reader["Phone"].ToString()
                    });
                }
            }
            return Json(customer, JsonRequestBehavior.AllowGet);
        }
}

I want email id and contact number to display on form page(cshtml)

change only url: "/CustomerController/GetCustmrDetails?id="+cusKey — Azhar
– Azhar, Commented Jan 21, 2019 at 6:12
url changed but still not working error function is executing — Cimy Riya
– Cimy Riya, Commented Jan 21, 2019 at 6:20
can anyone provide correct code to be placed in GetCustmrDetails function — Cimy Riya
– Cimy Riya, Commented Jan 21, 2019 at 6:22

Azhar · Accepted Answer · 2019-01-21 08:03:37Z

2

please use this one

  $("#CustomerList1").change(function (event) {
    var cusKey = $(this).val();
    alert("customerKey:" + cusKey);
    $.ajax({
        type: 'GET',
        url: "/Customer/GetCustmrDetails?id="+cusKey,
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        data: "{}",
        success: function (data) {
            alert("available");
            $("#EMailAddress").val(data[0].EMailAddress); 
            $('#Phone').val(data[0].Phone);
        },
        error: function () {
            alert("error");
        }
    });
});

edited Jan 21, 2019 at 8:03

answered Jan 21, 2019 at 6:35

Azhar

3435 silver badges11 bronze badges

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

7 Comments

Cimy Riya Over a year ago

still not fetching data from database table and not displaying the email and contact number in form

Azhar Over a year ago

now hitting to method GetCustmrDetails or not, check by puting debugger

Cimy Riya Over a year ago

yes hitting to method.thanks,but how to put debugger?

Cimy Riya Over a year ago

now alert available is also working but this code to display details not working $("#EMailAddress").val(data.EMailAddress); $('#Phone').val(data.Phone);

Cimy Riya Over a year ago

i got the code to display in correct format it's $("#EMailAddress").val(data[0].EMailAddress); $('#Phone').val(data[0].Phone);

|

Collectives™ on Stack Overflow

code to fetch and return database string data based on dropdown box onchange event through .net controller class to form page using ajax

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related