Json DataTable

最新推荐文章于 2025-02-13 09:23:29 发布

hnicypb

最新推荐文章于 2025-02-13 09:23:29 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： WEB 文章标签： json string each access binding javascript

本文链接：https://blog.youkuaiyun.com/hnicypb/article/details/2503522

WEB 专栏收录该内容

8 篇文章

订阅专栏

本文介绍两种将DataTable转换为JSON字符串的方法。一种适用于直接绑定到客户端表格，另一种则提供列名和数据，便于开发者使用。

在JS中我们需要对对象进行JSON序列化通常使用JSON.net, 不过它对DataTable的序列化不能很好的满足的我们的需求，

后来在CodeProject发现一个兄弟已经写好了 Convert ASP.NET DataTable to JSON, to use datatable in JAVASCRIPT ，记一下，免得忘记了。

public string JsonToDataTable(DataTable dt)
        {
            /****************************************************************************
             * Without goingin to the depth of the functioning of this Method, i will try to give an overview
             * As soon as this method gets a DataTable it starts to convert it into JSON String,
             * it takes each row and ineach row it creates an array of cells and in each cell is having its data
             * on the client side it is very usefull for direct binding of object to  TABLE.
             * Values Can be Access on clien in this way. OBJ.TABLE[0].ROW[0].CELL[0].DATA 
             * NOTE: One negative point. by this method user will not be able to call any cell by its name.
             * *************************************************************************/
            StringBuilder JsonString = new StringBuilder();
            JsonString.Append("{ ");
            JsonString.Append("/"TABLE/":[{ ");
            JsonString.Append("/"ROW/":[ ");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                JsonString.Append("{ ");
                JsonString.Append("/"COL/":[ ");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    if (j < dt.Columns.Count - 1)
                    {
                        JsonString.Append("{" + "/"DATA/":/"" + dt.Rows[i][j].ToString() + "/"},");
                    }
                    else if (j == dt.Columns.Count - 1)
                    {
                        JsonString.Append("{" + "/"DATA/":/"" + dt.Rows[i][j].ToString() + "/"}");
                    }
                }
                /*end Of String*/
                if (i == dt.Rows.Count - 1)
                {
                    JsonString.Append("]} ");
                }
                else
                {
                    JsonString.Append("]}, ");
                }
            }
            JsonString.Append("]}]}");
            return JsonString.ToString();
        }


        public string DataTableToJson(DataTable dt)
        {          
           /*****************************************************************************
            * Without goingin to the depth of the functioning of this Method, i will try to give an overview
            * As soon as this method gets a DataTable it starts to convert it into JSON String,
            * it takes each row and in each row it grabs the cell name and its data.
             * This kind of JSON is very usefull when developer have to have Column name of the .
            * Values Can be Access on clien in this way. OBJ.HEAD[0].
 
            * NOTE: One negative point. by this method user will not be able to call any cell by its index.
            * *************************************************************************/
            StringBuilder JsonString = new StringBuilder();
            //Exception Handling        
            if (dt != null && dt.Rows.Count > 0)
            {
                JsonString.Append("{ ");
                JsonString.Append("/"Head/":[ ");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    JsonString.Append("{ ");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        if (j < dt.Columns.Count - 1)
                        {
                            JsonString.Append("/"" + dt.Columns[j].ColumnName.ToString() + "/":" + "/"" + dt.Rows[i][j].ToString() + "/",");
                        }
                        else if (j == dt.Columns.Count - 1)
                        {
                            JsonString.Append("/"" + dt.Columns[j].ColumnName.ToString() + "/":" + "/"" + dt.Rows[i][j].ToString() + "/"");
                        }
                    }
                    /**/
                    /*end Of String*/
                    if (i == dt.Rows.Count - 1)
                    {
                        JsonString.Append("} ");
                    }
                    else
                    {
                        JsonString.Append("}, ");
                    }
                }
                JsonString.Append("]}");
                return JsonString.ToString();
            }
            else
            {
                return null;
            }
        }