2017年計(jì)算機(jī)三級數(shù)據(jù)庫知識：數(shù)據(jù)庫里的記錄與json之間的轉(zhuǎn)換

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
namespace OTC.Utility 
...{ 
public sealed class JSONHelper 
...{ 
/**//// 
/// 獲取JSON字符串 
/// 
/// 值 
/// 數(shù)據(jù)表名 
/// 
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(); 
} 
} 
}