string recordStr = JsonConvert.SerializeObject(array);
List<RECORD> test = JsonConvert.DeserializeObject<List<RECORD>>(recordStr );
GridView1.DataSource = test; string recordStr = JsonConvert.SerializeObject(array); List<RECORD> test = JsonConvert.DeserializeObject<List<RECORD>>(recordStr ); GridView1.DataSource = test;

(啊我慣用Newtonsoft,真的比較好替資料塑形,高手炮小力一點)

1、不管你用EF5/6或DBML,一定會有個資料模型,阿就是資料庫的CLASS,如下為員工識別卡TABLE

    public class V_EmpCardno
        public string EmpNo { get; set; }
        public string EmpCName { get; set; }
        public string CardNo { get; set; }
        public string 已離職 { get; set; }
        public char EmpType { get; set; }
        public string DeptCode { get; set; }

2、後端(asp.net)

    protected void Page_Load(object sender, EventArgs e)
        string act = Request.QueryString["act"];
        if (!string.IsNullOrEmpty(act))
            if (act == "hr")
                HRDataContext myHR = new HRDataContext();
                var data = myHR.V_EmpCardno.Where(p1 => p1.已離職 != "Y" && p1.CardNo.Trim() != "")
                    .OrderBy(o2 => o2.EmpNo)
                    .ToList<V_EmpCardno>();
                Response.Clear();
                Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(data));
                Response.End();

前端程式(以Winform/為例)

void formload(){
    var data = JsonConvert.DeserializeObject<List<V_EmpCardno>>(getWebResp("hr")); //下方有這個getWebResp函數的完整碼,示範只用到GET方式
    foreach(var d in data.Where(p=>p.EmpCName.StartWith("陳")){
        // ...... data已經是List,上行只列出姓陳的所有人員,用Lambda
        Console.Writeline(d.EmpCName); 
private string getWebResp(string v, string hostname = "www.yourcompany.com", List<KeyValuePair<string, string>> addKV = null)
    string targetUrl = $"https://{mainHostName}/getdata?act={v}";
    HttpWebRequest request = HttpWebRequest.Create(targetUrl) as HttpWebRequest;
    request.Method = "GET";
    request.ServerCertificateValidationCallback = delegate { return true; };
    request.ContentType = "application/x-www-form-urlencoded";
    request.Timeout = 15000;
    string result = "";
    // 取得網站方的回應資料
        using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
            using (StreamReader sr = new StreamReader(response.GetResponseStream()))
                result = sr.ReadToEnd();
    catch (Exception e)
        response.write($"錯誤發生:{e.Message}"
    return result;