JS提取JOSN数据。

后台转JOSN格式:

  TrainStudentBll bll = new TrainStudentBll();
            string where = " and a.STATUS=2";
            DataTable dtExpense = bll.GetExpenseId(id, where);
            if (dtExpense.Rows.Count > 0)
            {
                items.Append("[");
                for (int i = 0; i < dtExpense.Rows.Count; i++)
                {
                    items.Append("{");
                    items.Append(" \"SUBJECTID\":\"" + dtExpense.Rows[i]["SUBJECTID"].ToString() + "\",");
                    items.Append(" \"MONEY\":\"" + dtExpense.Rows[i]["MONEY"].ToString() + "\",");
                    if (dtExpense.Rows.Count - 1 == i)
                    {
                        items.Append(" \"REMARK\":\"" + dtExpense.Rows[i]["REMARK"].ToString() + "\"}");
                    }
                    else {
                        items.Append(" \"REMARK\":\"" + dtExpense.Rows[i]["REMARK"].ToString() + "\"},");
                    }
                }
                items.Append("]");

 

前台js遍历JOSN:

 var datas = '<%=items %>';
            if (datas != "") {
                var data = jQuery.parseJSON(datas);
                for (var o in data) {
                    subjects.push({ id: data[o].SUBJECTID, m: data[o].MONEY, r: data[o].REMARK });
                }
            }