jquery plug-in: Data Tables DataSource

2014-08-18

ASP.NET MVC 在Controller將IEnumerable<T> 轉成Data Tables datasource的陣列格式

CommonService comm = new CommonService();

IEnumerable<EmpEmail> emailList = comm.GetEmailList();

return Json(new { data = emailList.Select(x=>new []{x.Dept,x.Name,x.Email})},

                JsonRequestBehavior.AllowGet);

使用Ajax呼叫，會得到類似這種資料結果：

   1:  {

   2:    "data": [

   3:      [

   4:        "Tiger Nixon",

   5:        "System Architect",

   6:        "aaa@gmail.com"

   7:      ],

   8:      [

   9:        "Garrett Winters",

  10:        "Accountant",

  11:        "Tokyo@gmail.com"

  12:      ]

  13:  }