C#转化为json的一个问题

Question

      DataTable dt = ...
      Dictionary<Dictionary< string, string>, Dictionary<string, string>> dict = new Dictionary<Dictionary<string, string>, Dictionary<string, string>>();
      Dictionary<string, string> list = new Dictionary<string, string>();
      foreach (DataRow dr in dt.Rows) {
        dict.Add(??????);
      }    
      base.InjectJavaScript("var chartData=" +.......JavaScriptConvert.SerializeObject(dict), true);
      
      

要怎么写才能转化为以下的这种形式

           var chartData = [{
               "year": 1995,
               "cars": 1567
           }, {
               "year": 1996,
               "cars": 1617
           }
           ];

Answer 1

这个应该是很简单的。你只要做好model就行了，然后直接用JavaScriptConvert.SerializeObject就可以了。不需要Dictionary。

// 定义一个实体类
public class ChartData{
    public int Year{get;set;};
    public int Cars{get;set;};
}

List<ChartData> list=new List<ChartData>();
// 循环datatable然后把ChartData添加到list中
for(){
    list.Add(new ChartData{ Year=xxx,Cars=xxxxx});
}


var json=JavaScriptConvert.SerializeObject(list)