Asp.net将数据库里的记录转换成json

        using System;
  
using System.Collections.Generic;
  
using System.Text;
  
using System.Data;
  
using System.Data.SqlClient;
  
namespace OTC.Utility
  {
  
    public sealed class JSONHelper
      {

         
/// 获取JSON字符串
  
        ///
         
/// 数据表名
           public static string GetJSON(SqlDataReader drValue, string strTableName)
          {
               StringBuilder sb
= new StringBuilder();
               sb.AppendLine(
" { " );
               sb.AppendLine(
" " + strTableName + " :{ " );
               sb.AppendLine(
" records:[ " );
              
try
               {
  
                 while (drValue.Read())
                   {
                         sb.Append(
" { " );
                        
for ( int i = 0 ; i < drValue.FieldCount; i ++ )
                         {
                               sb.AppendFormat(
"" { 0 } " : " { 1 } " , " , drValue.GetName(i), drValue.GetValue(i));
                         }
                        sb.Remove(sb.ToString().LastIndexOf(’,’),
1 );
                        sb.AppendLine(
" }, " );
                   }
                   sb.Remove(sb.ToString().LastIndexOf(’,’),
1 );
               }
              
catch (Exception ex)
               {
                   
throw new Exception(ex.Message);
               }
  
             finally
               {
                    drValue.Close();
               }
              sb.AppendLine(
" ] " );
              sb.AppendLine(
" } " );
              sb.AppendLine(
" }; " );
             
return sb.ToString();
          }
     }
  }
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值