熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> .NET編程 >> 正文

DataSetToJson擴展方法

2022-06-13   來源: .NET編程 

   using System;

   using SystemCollectionsGeneric;

   using SystemLinq;

   using SystemText;

   using SystemData;

  

   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 Cant Do It To Json!;

                   }

                   if (JsonNameLength < )

                   {

                       return You Set The Json Name Is Wrong!;

                   }

                   if (dsTables[]ColumnsCount < ParNameLength)

                   {

                       return You Give The ParName Is Bigger Than DataSet Columns!;

                   }

                   string josn = { + JsonName + :[;

                   string temp = ;

                   for (int j = ; j < dsTables[]RowsCount; j++)

                   {

                       temp = temp + {;

                       for (int i = ; i < ParNameLength; i++)

                       {

                           temp += + ParName[i] + :\ + dsTables[]Rows[j][ParName[i]] + \;

                           if (i != ParNameLength )

                           {

                               temp = temp + ;

                           }

                       }

                       if (j == dsTables[]RowsCount )

                       {

                           temp = temp + };

                       }

                       else

                       {

                           temp = temp + };

                       }

                   }

                   josn = josn + temp + ]};

                   return josn;

               }

               catch (Exception ex)

               {

                   return Codeing is Error + exToString();

               }

  

           }

  

           #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 Cant Do It To Json!;

                   }

                   string josn = [;

                   string temp = ;

                   for (int j = ; j < dsTables[]RowsCount; j++)

                   {

                       temp = temp + {;

                       for (int i = ; i < dsTables[]ColumnsCount; i++)

                       {

                           temp += + dsTables[]Columns[i]ColumnName + :\ + dsTables[]Rows[j][i] + \;

                           if (i != dsTables[]ColumnsCount )

                           {

                               temp = temp + ;

                           }

                       }

                       if (j == dsTables[]RowsCount )

                       {

                           temp = temp + };

                       }

                       else

                       {

                           temp = temp + };

                       }

                   }

                   josn = josn + temp + ];

                   return josn;

               }

               catch (Exception ex)

               {

                   return Codeing is Error + exToString();

               }

  

           }

           #endregion

       }

   }


From:http://tw.wingwit.com/Article/program/net/201311/13507.html
    推薦文章
    Copyright © 2005-2022 電腦知識網 Computer Knowledge   All rights reserved.