Load a javascript array using c# into a C# DataTable

Question

I need to read a javascript array from a .js file. The .js file has comments "//..." as well. Here's what the file looks like :

var myarraydata = [ 
{
    col1: "value1", 
    col2: "value2", 
    col3: "value3"
},
{
    col1: "x1", 
    col2: "x2", 
    col3: "x3"
}];

In the C# windows application. A DataTable? with

columns : col1    col2    col3
Values  : value1  value2  value3
          x1      x2      x3

....Something like

File.ReadAllText(....
//Parse the data

@Liam JSON and JavaScript are not the same thing. That is not a valid JSON file. — user229044
– user229044 ♦, Commented Nov 20, 2015 at 14:21

BendEg · Accepted Answer · 2015-11-20 13:39:02Z

4

JavaScript arrays are representable with JSON objects. So you may could serialize and deserialize them using Newtonsoft.Json. Please correct me if i am wrong.

Just take a look at: Json.NET

EDIT

Newtonsoft.Json is release under the MIT license. So you should be able to embed the source code directly, if needed. But in your case i would use the assembly, because updating to a newer version will be much easier.

edited Nov 20, 2015 at 13:39

answered Nov 20, 2015 at 13:24

BendEg

21.3k17 gold badges69 silver badges135 bronze badges

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

3 Comments

user2185210 Over a year ago

thank you. Any points at not having to do this without including additional libraries?

BendEg Over a year ago

Write your own JSON serialization. But you might download the sources of it and embed it into yours, if the licenses allows this. But the library is very lightweight and excellent to use.

user2185210 Over a year ago

Tx. I think I'll do some string parsing directly in c# and split the values using a basic regex. May be clunky but should avoid a bit of code. Thought someone may have a better approach than my initial thoughts. Some model view scenario etc...:)

user2185210 · Accepted Answer · 2015-11-21 03:44:03Z

If anyones interested, I got this working using the standard .net classes :)

Microsoft Reference

Here's sample code from the website :

using System;
using System.Collections.Generic;
using System.Web.UI;
using System.Web.Script.Serialization;

namespace ExampleApplication
{
    public partial class _Default : Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            var RegisteredUsers = new List<Person>();
            RegisteredUsers.Add(new Person() { PersonID = 1, Name = "Bryon Hetrick", Registered = true });
            RegisteredUsers.Add(new Person() { PersonID = 2, Name = "Nicole Wilcox", Registered = true });
            RegisteredUsers.Add(new Person() { PersonID = 3, Name = "Adrian Martinson", Registered = false });
            RegisteredUsers.Add(new Person() { PersonID = 4, Name = "Nora Osborn", Registered = false });

            var serializer = new JavaScriptSerializer();
            var serializedResult = serializer.Serialize(RegisteredUsers);
            // Produces string value of:
            // [
            //     {"PersonID":1,"Name":"Bryon Hetrick","Registered":true},
            //     {"PersonID":2,"Name":"Nicole Wilcox","Registered":true},
            //     {"PersonID":3,"Name":"Adrian Martinson","Registered":false},
            //     {"PersonID":4,"Name":"Nora Osborn","Registered":false}
            // ]

            var deserializedResult = serializer.Deserialize<List<Person>>(serializedResult);
            // Produces List with 4 Person objects
        }
    }
}

Thank you MS

Collectives™ on Stack Overflow

Load a javascript array using c# into a C# DataTable

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related