DataSetToJson 扩展方法

最新推荐文章于 2021-08-16 12:10:03 发布

转载最新推荐文章于 2021-08-16 12:10:03 发布 · 89 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/simonblog/archive/2010/05/12/1733139.html

文章标签：

#json

本文介绍了一种将DataSet转换为JSON格式的方法，并提供了两个扩展方法的实现：一个接受额外参数来指定字段名，另一个直接将所有列转换为JSON。这些方法可用于.NET应用程序中，帮助开发者轻松地将数据库数据转换为JSON格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace Common
{

    public static class JsonExtensions
    {
        #region DataSetToJson 扩展方法
        /// <summary>
        /// DataSetToJson 扩展方法
        /// </summary>
        /// <param name="ds">要传入的DataSet</param>
        /// <param name="JsonName">Json的名称</param>
        /// <param name="ParName">Json字段名称</param>
        /// <returns>返回JSON字符串</returns>
        public static string DataSetToJson(this DataSet ds, string JsonName, string[] ParName)
        {
            try
            {
                if (ds == null)
                {
                    return "DataSet Is Null ,So I Can't Do It To Json!";
                }
                if (JsonName.Length < 1)
                {
                    return "You Set The Json Name Is Wrong!";
                }
                if (ds.Tables[0].Columns.Count < ParName.Length)
                {
                    return "You Give The ParName Is Bigger Than DataSet Columns!";
                }
                string josn = "{" + JsonName + ":[";
                string temp = "";
                for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
                {
                    temp = temp + "{";
                    for (int i = 0; i < ParName.Length; i++)
                    {
                        temp += "" + ParName[i] + ":\'" + ds.Tables[0].Rows[j][ParName[i]] + "\'";
                        if (i != ParName.Length - 1)
                        {
                            temp = temp + ",";
                        }
                    }
                    if (j == ds.Tables[0].Rows.Count - 1)
                    {
                        temp = temp + "}";
                    }
                    else
                    {
                        temp = temp + "},";
                    }
                }
                josn = josn + temp + "]}";
                return josn;
            }
            catch (Exception ex)
            {
                return "Codeing is Error----" + ex.ToString();
            }

        }

        #endregion

        #region  DataSetToJson 扩展方法
        /// <summary>
        /// DataSetToJson 扩展方法
        /// </summary>
        /// <param name="ds">要传入的DataSet</param>
        /// <returns>返回JSON字符串<</returns>
        public static string DataSetToJson(this DataSet ds)
        {
            try
            {
                if (ds == null)
                {
                    return "DataSet Is Null ,So I Can't Do It To Json!";
                }
                string josn = "[";
                string temp = "";
                for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
                {
                    temp = temp + "{";
                    for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
                    {
                        temp += "" + ds.Tables[0].Columns[i].ColumnName + ":\'" + ds.Tables[0].Rows[j][i] + "\'";
                        if (i != ds.Tables[0].Columns.Count - 1)
                        {
                            temp = temp + ",";
                        }
                    }
                    if (j == ds.Tables[0].Rows.Count - 1)
                    {
                        temp = temp + "}";
                    }
                    else
                    {
                        temp = temp + "},";
                    }
                }
                josn = josn + temp + "]";
                return josn;
            }
            catch (Exception ex)
            {
                return "Codeing is Error----" + ex.ToString();
            }

        }
        #endregion
    }
}

转载于:https://www.cnblogs.com/simonblog/archive/2010/05/12/1733139.html