开发者社区> 问答> 正文

webservice写的json格式客户端无法读出

json

网上看到很多解答,但我没搞定。
下面是我写的带代码
封装函数

public DataSet js()
 {
 string sql = "select * from friend";
 SqlCommand cmd = new SqlCommand(sql, con);
 //SqlDataReader da = cmd.ExecuteReader();
 SqlDataAdapter da = new SqlDataAdapter(cmd);
 DataSet ds = new DataSet();
 da.Fill(ds);
 cmd.Dispose();
 return ds;
 }

转化数据

public string js()
 {
 StringBuilder sb = new StringBuilder();
    DataTable dt = dbOperation.js().Tables[0];
    sb.Append("{User:[");
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        sb.Append("{\"userid\":\"" + dt.Rows[i]["userid"].ToString() + "\",\"name\":\"" + dt.Rows[i]["name"].ToString() + "\",\"password\":\"" + dt.Rows[i]["password"].ToString() + "\",\"text\":\"" + dt.Rows[i]["text"].ToString() + "\"}");
        if (i != dt.Rows.Count - 1)
        {
            sb.Append(",");
        }
    }
    sb.Append("]}");
    return sb.ToString();

}

运行效果

<?xml version="1.0" encoding="UTF-8"?>
{User:[{"userid":"123456","name":"吉旺","password":"123456 ","text":"asd"},{"userid":"41238","name":"华小坑","password":"123456 ","text":""}]}

客户端读取

var Service=function() {
 Service.initializeBase(this);
 this._timeout = 0;
 this._userContext = null;
 this._succeeded = null;
 this._failed = null;
 }
 Service.prototype={
 _get_path:function() {
 var p = this.get_path();
 if (p) return p;
 else return Service._staticInstance.get_path();},
 HelloWorld:function(succeededCallback, failedCallback, userContext) {
 return this._invoke(this._get_path(), 'HelloWorld',false,{},succeededCallback,failedCallback,userContext); },
 selectAllUser:function(succeededCallback, failedCallback, userContext) {
 return this._invoke(this._get_path(), 'selectAllUser',false,{},succeededCallback,failedCallback,userContext); },
 insertUser:function(name,pwd,succeededCallback, failedCallback, userContext)

麻烦帮助一下

展开
收起
杨冬芳 2016-07-04 15:36:20 2120 0
1 条回答
写回答
取消 提交回答
  • IT从业

    用WebService只能返回一个json格式的字符串

    2019-07-17 19:50:44
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载