public string GroupNameLoadByActivity(string ActivityId) { string jsonString = ""; DataTable dtResult; DefaultManager.DBReturnCode retCode = DefaultManager.GroupNameLoadByActivity(ActivityId, out dtResult);; if (DefaultManager.DBReturnCode.SUCCESS == retCode) { jsonString = ""; foreach (DataRow dr in dtResult.Rows) { jsonString += "{"; foreach (DataColumn dc in dtResult.Columns) { jsonString += "\"" + dc.ColumnName + "\":\"" + escapejosndata(dr[dc].ToString().Replace("\r\n", " ")) + "\","; } jsonString = jsonString.Trim(',') + "},"; } jsonString = "{\"Session\":\"1\",\"retCode\":\"1\",\"MyGroup\":[" + jsonString.Trim(',') + "]}"; dtResult.Dispose(); return(jsonString); } else { return("{\"Session\":\"1\",\"retCode\":\"0\"}"); } }