protected string ConverTableToJSON2(DataTable table) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("["); if (table != null && table.Rows.Count > 0) { for (int i = 0; i < table.Rows.Count; i++) { if (i > 0) { stringBuilder.Append(","); } stringBuilder.Append("{"); for (int j = 0; j < table.Columns.Count; j++) { if (!string.IsNullOrEmpty(string.Concat(table.Rows[i][j]))) { if (j > 0) { stringBuilder.Append(","); } stringBuilder.Append("\"" + table.Columns[j].ColumnName.ToLower() + "\":\""); stringBuilder.Append(ComData.NoHTML(table.Rows[i][j].ToString()) + "\""); } } stringBuilder.Append("}"); } } stringBuilder.Append("]"); return(stringBuilder.ToString()); }
protected string ConverTableToJSON2(DataTable table) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("["); if (table != null && table.Rows.Count > 0) { for (int index1 = 0; index1 < table.Rows.Count; ++index1) { if (index1 > 0) { stringBuilder.Append(","); } stringBuilder.Append("{"); for (int index2 = 0; index2 < table.Columns.Count; ++index2) { if (!string.IsNullOrEmpty(string.Concat(table.Rows[index1][index2]))) { if (index2 > 0) { stringBuilder.Append(","); } stringBuilder.Append("\"" + table.Columns[index2].ColumnName.ToLower() + "\":\""); stringBuilder.Append(ComData.NoHTML(table.Rows[index1][index2].ToString()) + "\""); } } stringBuilder.Append("}"); } } stringBuilder.Append("]"); return(stringBuilder.ToString()); }