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(); 生成json的一个方法