• csharp_ToJson的正确写法


    网上搜的,但有问题,已经改好。。。现在这个是正确的

            public static string ToJson(DataTable dt, string jsonName)
            {
                StringBuilder Json = new StringBuilder();
                if (string.IsNullOrEmpty(jsonName))
                    jsonName = dt.TableName;
                Json.Append("{"" + jsonName + "":[");
                //Json.Append("{"" + jsonName + "":");
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Json.Append("{");
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            Type type = dt.Rows[i][j].GetType();
                            if (type.Name.ToString() == "Int32")
                            {
                                Json.Append(""" + dt.Columns[j].ColumnName.ToString() + "":" + String.Format(dt.Rows[i][j].ToString(), type));
                            }
                            else
                            {
                                Json.Append(""" + dt.Columns[j].ColumnName.ToString() + "":"" + String.Format(dt.Rows[i][j].ToString(), type));
                            }
                            if (j < dt.Columns.Count - 1)
                            {
                                if (type.Name.ToString() == "Int32")
                                {
                                    Json.Append(",");
                                }
                                else
                                {
                                    Json.Append("",");
                                }
                            }
                        }
                        Json.Append(""}");
                        if (i < dt.Rows.Count - 1)
                        {
                            Json.Append(",");
                        }
                    }
                }
                Json.Append("]}");
                //Json.Append("}");
                return Json.ToString();
            }
        }
    }

  • 相关阅读:
    详解Oracle临时表的几种用法及意义
    Testing and Debugging Procedures using SQL Developer 3.1
    ORACLE 流复制
    ORA01017 invalid username/password; logon denied
    oracle数据类型
    使用Pls_Integer的好处
    js取得上传图片大小
    高效整洁CSS代码原则
    在线压缩js和css
    图片等比例缩放后裁切
  • 原文地址:https://www.cnblogs.com/weiryang/p/3208155.html
Copyright © 2020-2023  润新知