Deserialized an object into a DataTable

up vote
0
down vote

favorite

I have a JSON response like this:

{  "cod": "OK", 

"list": [

    {  "date": "31/10/2018", "count": "109",  "name": "PAUL"  },

    {  "date": "30/09/2018", "count": "103",  "name": "LUKE"  }

]}

I use:

 Dim jss As New JavaScriptSerializer

 Dim Response = jss.Deserialize(Of Object)(strResponse)

 Dim Cod = Response("cod")

Then:

Dim Lista_documents = Response("list")

And I have an object with the list of documents.

How can I populate a new DataTable?

edited Nov 10 at 9:50

Jimi

6,01621033

asked Nov 10 at 8:25

LukaGer

You didn't explain how you want to populate it.
– CruleD
Nov 10 at 13:07

add a comment |

up vote
0
down vote

favorite

I have a JSON response like this:

{  "cod": "OK", 

"list": [

    {  "date": "31/10/2018", "count": "109",  "name": "PAUL"  },

    {  "date": "30/09/2018", "count": "103",  "name": "LUKE"  }

]}

I use:

 Dim jss As New JavaScriptSerializer

 Dim Response = jss.Deserialize(Of Object)(strResponse)

 Dim Cod = Response("cod")

Then:

Dim Lista_documents = Response("list")

And I have an object with the list of documents.

How can I populate a new DataTable?

edited Nov 10 at 9:50

Jimi

6,01621033

asked Nov 10 at 8:25

LukaGer

You didn't explain how you want to populate it.
– CruleD
Nov 10 at 13:07

add a comment |

up vote
0
down vote

favorite

I have a JSON response like this:

{  "cod": "OK", 

"list": [

    {  "date": "31/10/2018", "count": "109",  "name": "PAUL"  },

    {  "date": "30/09/2018", "count": "103",  "name": "LUKE"  }

]}

I use:

 Dim jss As New JavaScriptSerializer

 Dim Response = jss.Deserialize(Of Object)(strResponse)

 Dim Cod = Response("cod")

Then:

Dim Lista_documents = Response("list")

And I have an object with the list of documents.

How can I populate a new DataTable?

edited Nov 10 at 9:50

Jimi

6,01621033

asked Nov 10 at 8:25

LukaGer

I have a JSON response like this:

{  "cod": "OK", 

"list": [

    {  "date": "31/10/2018", "count": "109",  "name": "PAUL"  },

    {  "date": "30/09/2018", "count": "103",  "name": "LUKE"  }

]}

I use:

 Dim jss As New JavaScriptSerializer

 Dim Response = jss.Deserialize(Of Object)(strResponse)

 Dim Cod = Response("cod")

Then:

Dim Lista_documents = Response("list")

And I have an object with the list of documents.

How can I populate a new DataTable?

json vb.net datatable

edited Nov 10 at 9:50

Jimi

6,01621033

asked Nov 10 at 8:25

LukaGer

edited Nov 10 at 9:50

Jimi

6,01621033

asked Nov 10 at 8:25

LukaGer

edited Nov 10 at 9:50

Jimi

6,01621033

edited Nov 10 at 9:50

Jimi

6,01621033

edited Nov 10 at 9:50

Jimi

6,01621033

asked Nov 10 at 8:25

LukaGer

asked Nov 10 at 8:25

LukaGer

asked Nov 10 at 8:25

LukaGer

You didn't explain how you want to populate it.
– CruleD
Nov 10 at 13:07

add a comment |

You didn't explain how you want to populate it.
– CruleD
Nov 10 at 13:07

You didn't explain how you want to populate it.
– CruleD
Nov 10 at 13:07

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

I am not aware of any methods that will do it automatically, so probably with a Loop.

Dim table As New DataTable

table.Columns.Add("date", GetType(Date))

table.Columns.Add("count", GetType(Integer))

table.Columns.Add("name", GetType(String))



For Each Li In Lista_documents

    table.Rows.Add(Li("date"), Li("count"), Li("name"))

Next

Adjust depending on how your Lista_documents is structured

edited Nov 10 at 16:35

answered Nov 10 at 16:04

Simon Evans

11617

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53237253%2fdeserialized-an-object-into-a-datatable%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

I am not aware of any methods that will do it automatically, so probably with a Loop.

Dim table As New DataTable

table.Columns.Add("date", GetType(Date))

table.Columns.Add("count", GetType(Integer))

table.Columns.Add("name", GetType(String))



For Each Li In Lista_documents

    table.Rows.Add(Li("date"), Li("count"), Li("name"))

Next

Adjust depending on how your Lista_documents is structured

edited Nov 10 at 16:35

answered Nov 10 at 16:04

Simon Evans

11617

add a comment |

up vote
0
down vote

I am not aware of any methods that will do it automatically, so probably with a Loop.

Dim table As New DataTable

table.Columns.Add("date", GetType(Date))

table.Columns.Add("count", GetType(Integer))

table.Columns.Add("name", GetType(String))



For Each Li In Lista_documents

    table.Rows.Add(Li("date"), Li("count"), Li("name"))

Next

Adjust depending on how your Lista_documents is structured

edited Nov 10 at 16:35

answered Nov 10 at 16:04

Simon Evans

11617

add a comment |

up vote
0
down vote

I am not aware of any methods that will do it automatically, so probably with a Loop.

Dim table As New DataTable

table.Columns.Add("date", GetType(Date))

table.Columns.Add("count", GetType(Integer))

table.Columns.Add("name", GetType(String))



For Each Li In Lista_documents

    table.Rows.Add(Li("date"), Li("count"), Li("name"))

Next

Adjust depending on how your Lista_documents is structured

edited Nov 10 at 16:35

answered Nov 10 at 16:04

Simon Evans

11617

I am not aware of any methods that will do it automatically, so probably with a Loop.

Dim table As New DataTable

table.Columns.Add("date", GetType(Date))

table.Columns.Add("count", GetType(Integer))

table.Columns.Add("name", GetType(String))



For Each Li In Lista_documents

    table.Rows.Add(Li("date"), Li("count"), Li("name"))

Next

Adjust depending on how your Lista_documents is structured

edited Nov 10 at 16:35

answered Nov 10 at 16:04

Simon Evans

11617

edited Nov 10 at 16:35

answered Nov 10 at 16:04

Simon Evans

11617

answered Nov 10 at 16:04

Simon Evans

11617

answered Nov 10 at 16:04

Simon Evans

11617

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk