如何在JSON对象/数组中添加多个对象? [英] How to add multiple object in JSON object/array?
本文介绍了如何在JSON对象/数组中添加多个对象?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好,
Bellow是我用C#编写的Web服务。
在这里,我从数据库中获得了一个返回值和一个表。
我想将它合并为单个JSON对象/数组。我该怎么办..?
con.Open();
SqlDataAdapter da = new SqlDataAdapter(UpdateUserInfo2,con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(@ UserAutoId,SqlDbType.VarChar).Value = UserAutoId;
da.SelectCommand.Parameters.Add(@ userId,SqlDbType.VarChar).Value = userId;
da.SelectCommand.Parameters.Add(@ firstName,SqlDbType.VarChar).Value = fname;
da.SelectCommand.Parameters.Add(@ lastName,SqlDbType.VarChar).Value = lname;
da.SelectCommand.Parameters.Add(@ emailadr,SqlDbType.VarChar).Value = email;
da.SelectCommand.Parameters.Add(@ hieght,SqlDbType.VarChar).Value = hieght;
da.SelectCommand.Parameters.Add(@ retValue,System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue;
da.Fill(tbl);
int retval =(int)da.SelectCommand.Parameters [@ retValue]。Value;
if(retval == 1)
{
string result =1;
//这里我要合并表Object(tbl)和返回值(result)
json = new JavaScriptSerializer()。Serialize(result);
}
else if(retval == 2)
{
string result =2;
json = new JavaScriptSerializer()。Serialize(result);
}
con.Close();
返回json;
}
我的尝试:
我试图更新数据库上的单个记录并响应查询获取,我想得到更新的表和返回值(或任何对象)。
解决方案
从返回表格从SP
然后
JSONArray obj = new JSONArray();
尝试 {
for ( int i = 0 ; i< table.rows.count; i ++){
/ / 第一个对象
JSONObject list1 = new JSONObject();
list1.put( val1,i + 1);
list1.put( val2,i + 2);
list1.put( val3,i + 3);
obj.put(list1);
}
} catch (JSONException e1){
// TODO自动生成的捕获块
e1.printStackTrace();
}
Toast.makeText(MainActivity。 this , + obj,Toast.LENGTH_LONG)。show();
{
emp:[
{
employeeId:52374,
employeeName:Mayuresh Chaudhary,
employeePhone:7888119073,
项目:ZENLABS_IIOT,
经理:Vikram Samdare,
状态:不活跃,
资产:[
{
assetsNo:30003,
description:HP Pavilion - Laptop,
type:LAPTOP,
assetsStatus:成功
}
],
manangerPhone:8888801154
},
{
employeeId:42177,
employeeName:Nilesh Parekh,
emp loyeePhone:9764696566,
project:ZENLABS_IIOT,
经理:Vikram Samdare,
manangerPhone: 8888801154,
状态:有效,
资产:[
{
assetsNo :30001,
description:HP Pavilion - Laptop,
type:LAPTOP,
assetsStatus :危险
},
{
assetsNo:30005,
description: HP Pavilion - 笔记本电脑,
类型:LAPTOP,
assetsStatus:成功
}
]
}
],
消息:资产不匹配
}
hello,
Bellow is My Web Service written in C#.
In this, I got a return value and a table from database.
I want to merge it into single JSON Object/Array. How can I do it..?
con.Open(); SqlDataAdapter da = new SqlDataAdapter("UpdateUserInfo2 ", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@UserAutoId", SqlDbType.VarChar).Value = UserAutoId; da.SelectCommand.Parameters.Add("@userId", SqlDbType.VarChar).Value = userId; da.SelectCommand.Parameters.Add("@firstName", SqlDbType.VarChar).Value = fname; da.SelectCommand.Parameters.Add("@lastName", SqlDbType.VarChar).Value = lname; da.SelectCommand.Parameters.Add("@emailadr", SqlDbType.VarChar).Value = email; da.SelectCommand.Parameters.Add("@hieght", SqlDbType.VarChar).Value = hieght; da.SelectCommand.Parameters.Add("@retValue", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.ReturnValue; da.Fill(tbl); int retval = (int)da.SelectCommand.Parameters["@retValue"].Value; if (retval == 1) { string result = "1"; //Here I want to merge table Object(tbl) and return value (result) json = new JavaScriptSerializer().Serialize(result); } else if (retval == 2) { string result = "2"; json = new JavaScriptSerializer().Serialize(result); } con.Close(); return "json"; }
What I have tried:
I trying to update single record on database and in response to query fetch, I want to get updated table and return value(or any object).
解决方案
From return Table From SP
then
JSONArray obj = new JSONArray(); try { for(int i = 0; i <table.rows.count; i++) { // 1st object JSONObject list1 = new JSONObject(); list1.put("val1",i+1); list1.put("val2",i+2); list1.put("val3",i+3); obj.put(list1); } } catch (JSONException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } Toast.makeText(MainActivity.this, ""+obj, Toast.LENGTH_LONG).show();
{ "emp": [
{
"employeeId": 52374,
"employeeName": "Mayuresh Chaudhary",
"employeePhone": 7888119073,
"project": "ZENLABS_IIOT",
"manager": "Vikram Samdare",
"status": "inactive",
"assets": [
{
"assetsNo": 30003,
"description": "HP Pavilion - Laptop",
"type": "LAPTOP",
"assetsStatus": "success"
}
],
"manangerPhone": 8888801154
},
{
"employeeId": 42177,
"employeeName": "Nilesh Parekh",
"employeePhone": 9764696566,
"project": "ZENLABS_IIOT",
"manager": "Vikram Samdare",
"manangerPhone": 8888801154,
"status": "active",
"assets": [
{
"assetsNo": 30001,
"description": "HP Pavilion - Laptop",
"type": "LAPTOP",
"assetsStatus": "danger"
},
{
"assetsNo": 30005,
"description": "HP Pavilion - Laptop",
"type": "LAPTOP",
"assetsStatus": "success"
}
]
}
],
"message": "Asset Mismatch"
}
这篇关于如何在JSON对象/数组中添加多个对象?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文