示例#1
0
        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());
        }
示例#2
0
        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());
        }