日期:2014-05-16 浏览次数:20749 次
StringBuilder retVal = new StringBuilder();
retVal.Append("{list:[");
using (SqlDataReader reader = db.ExecuteReader(CommandType.Text, sql))
{
while (reader.Read())
{
retVal.Append("{");
for (int i = 0; i < reader.FieldCount; i++)
{
retVal.AppendFormat("{0}:'{1}'{2}", reader.GetName(i).Trim(), reader[i].ToString().Trim(), i == reader.FieldCount - 1 ? "" : ",");
}
retVal.Append("},");
}
}
retVal.Remove(retVal.Length - 1, 1);
retVal.Append("]}");
return retVal.ToString();