我正在执行一个ajax调用,以检索从查询返回的JSON数据。我的JSON (准确地)返回以下内容:
[{
"label": "",
"value": "2302"
}, {
"label": "9 - Contract set-up in EPICOR",
"value": "2280"
}, {
"label": "2 - Verify PO received",
"value": "2279"
}, {
"label": "7 - Review quote and prepare team for meeting",
"value": "2281"
}]
但我需要它真正的返回:
{
"options": {
"logan_dvprTasks.taskID": {
[{
"label": "",
"value": "2302"
}, {
"label": "9 - Contract set-up in EPICOR",
"value":"2280"
}, {
"label": "2 - Verify PO received",
"value":"2279"
}, {
"label": "7 - Review quote and prepare team for meeting",
"value":"2281"
}]
}
}
我拥有的生成JSON的代码是:
public IEnumerable<updatetasks> GetAllItems(string dvprid)
{
string stringSQL = "sqlStatement goes here";
string connString = ConfigurationManager.ConnectionStrings["loganWebConn"]
.ConnectionString;
using (SqlConnection sqlConnection = new SqlConnection(connString))
{
sqlConnection.Open();
using (SqlCommand cmd = sqlConnection.CreateCommand())
{
cmd.CommandText = stringSQL;
cmd.CommandType = CommandType.Text;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var updatetasks = new updatetasks();
updatetasks.label = reader["taskName"].ToString();
updatetasks.value = reader["taskID"].ToString();
yield return updatetasks;
}
}
}
}
}
如何修改我的C#代码,以便在JSON对象的开头添加这两项?
https://stackoverflow.com/questions/41333387
复制相似问题