如何将反序列化的JSON数据添加/映射到.mdf数据库/数据表 [英] How to add/map Deserialized JSON data to .mdf Database/datatable

问题描述

大家好！我很困惑，我是编程新手，我需要专业人士的帮助。我有基于mdf的数据库，以及web服务器上的json数据。我必须从Web下载所有数据，然后反序列化并添加到mdf datatable。有人帮助我。



Json数据：

[{id：13422，user_name：HaMe，id_number ：888888887052，card_number：297c2231，早餐：1111100，午餐：1111100，晚餐：0000000，start_date：01/10/2015 00:01 ，end_date：25/05/2016 23:59，食堂：Askhana 1，only_once：false}，

{id：13516，user_name ： КаBa， ID_NUMBER： 888888887400， CARD_NUMBER： 293ca641， 早餐： 1111111， lunchs： 1111111， 晚餐： 1111111， 起始日期： 11/10/2015 00:01，end_date：2015年12月31日23:59，食堂：Askhana 1，only_once：true}，

Hi, everyone! I'm confused, i am new in programming and i need to professionals' help. I have mdf based database, and json data on web server. I must download all data from Web, and deserialize it and add to mdf datatable. Somebody help me.

Json Data:
[ {"id":13422,"user_name":"HaMe","id_number":"888888887052","card_number":"297c2231","breakfasts":"1111100","lunchs":"1111100","dinners":"0000000","start_date":"01/10/2015 00:01","end_date":"25/05/2016 23:59","canteen":"Askhana 1","only_once":false},
{"id":13516,"user_name":"КаBa","id_number":"888888887400","card_number":"293ca641","breakfasts":"1111111","lunchs":"1111111","dinners":"1111111","start_date":"11/10/2015 00:01","end_date":"31/12/2015 23:59","canteen":"Askhana 1","only_once":true},

推荐答案

using System;
using System.Collections.Generic;
using System.Net;
using System.Web.Script.Serialization;
public partial class Practice : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        List<YourClassName> objYourClass = downloadJsonData("http:/185.98.5.184:9000/users/dealed/Test");//use this class properties where ever necessary
    }
    private static List<YourClassName> downloadJsonData(string url) 
    {
        var w = new WebClient();
        var jData= w.DownloadString(url);
        return !string.IsNullOrEmpty(jData) ? new JavaScriptSerializer().Deserialize<List<YourClassName>>(jData) : null ;
    }
}
public class YourClassName
{
    public int id { get; set; }
    public string user_name { get; set; }
    public string card_number { get; set; }
    public string breakfasts { get; set; }
    public string lunchs { get; set; }
    public string dinners { get; set; }
    public string start_date { get; set; }
    public string end_date { get; set; }
    public string canteen { get; set; }
    public bool only_once { get; set; }
    //public List<object> gtransactions { get; set; } //in this case u don't need to declare Gtransactions class
    //public List<Gtransactions> gtransactions { get; set; } //in this case avoids boxing unboxing 
    public Gtransactions[] gtransactions { get; set; } //in this case avoids boxing unboxing as well 
    public string id_number { get; set; }
}
public class Gtransactions
{
    public string gdeal_id { get; set; }
    public string meal_time { get; set; }
    public bool jana { get; set; } 
}

这篇关于如何将反序列化的JSON数据添加/映射到.mdf数据库/数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！