I want pass data json from C# to javascript but not work

Question

0.00/5 (No votes)

See more:

I have this code in c#

public string DataTableToJSONWithJSONNet(DataTable table)
    {
        string JSONString = string.Empty;
        JSONString = JsonConvert.SerializeObject(table);
        return JSONString;
    }



 protected void btnpoint_Click(object sender, EventArgs e)
    {
        string ConnectionString = Config.GetConnectionString();
        SqlDataAdapter da = new SqlDataAdapter("select latitude,longitude from FrmEducateReport01   ", new SqlConnection(ConnectionString));
        DataTable dt = new DataTable();                                        
        da.Fill(dt);
      
        jsondata = DataTableToJSONWithJSONNet(dt);

    }

and in javascript

var arr = JSON.parse('<%=jsondata%>');

but not work and I want to access to items in jsondata

What I have tried:

dont work for example alart(arr); not work

Posted 2-Aug-20 20:10pm

farshid20

Updated 3-Aug-20 1:04am

Garth J Lancaster

v3

Add a Solution

Comments

Sandeep Mewara 3-Aug-20 2:58am

Can you explain on what is the issue you are facing when you tried?

UPDATE: Second thought, will share what I think.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2020-08-02T21:01:00

Something like below should help:
Client Code:

JavaScript

$("#Customer").change(function () {
            var name = $("[id*='Customer'] :selected").text();
            $.ajax({
                url: '/Sale/getCustomerId',
                datatype: "json",
                type: "POST",
                contentType: 'application/json; charset=utf-8',
                data: JSON.stringify({ CusName: name }),
                async: true,
                processData: false,
                cache: false,

                success: function (Data) {
                    cusid= Data;
                },
                error : function (xhr) {
                    //  alert("error");
                    return null;
                },
                error: function (exception) {
                   // alert('Exeption:' + exception);
                    swal("Ooops", 'Exeption:' + exception, "error");
                }
            })       
        })

Server code:

C#

public JsonResult getCustomerId(string CusName)
       {

           // get data

           return Json (result);
       }

Similar question, refer: Ajax call in ASP MVC not working[^]

F-ES Sitecore · Answer 2 · 2020-08-03T01:04:00

"Doesn't work" doesn't give anyone enough information to help you. Do you get an error or do you just not get what you expect? Your code works fine for me, if you want to get meaningful data from the json then "alert(arr)" isn't going to do it, you can parse the data like this

JavaScript

var arr = JSON.parse('<%=jsondata%>');
for (var i = 0; i < arr.length; i++) {
    alert(arr[i].latitude + ", " + arr[i].longitude);
}

If that's not your problem then you'll have to explain more about what the issue is.

I want pass data json from C# to javascript but not work

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0