日期:2014-05-16 浏览次数:20747 次
 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();