How to return datatable data in array jason form in web Ap

Sandeep kumar

5y668

I NEED IN THIS FORM OF DATA.Please help me

data: [

["10/05/2021", 5, 6,6],

["11/05/2021", 8, 9,4],

["12/05/2021", 4, 6,2],

["13/05/2021", 6, 5,6],

["14/05/2021", 4, 3,3],

["15/05/2021", 7, 7,4],

["16/05/2021", 8, 6,1],

Controller Part Code

//http://localhost:58231/api/ManageCovidInfo/GetCovidAbsentismGrapgh
//
// [Authorize]
[HttpPost]
public HttpResponseMessage GetCovidAbsentismGrapgh(JObject jsonParam)
{
try
{
// UserIdentity UI = new UserIdentity((ClaimsIdentity)User.Identity);
// var UserID = Convert.ToInt32(UI.UserID);
ManageCovidInfo _MCI = new ManageCovidInfo();
var CD_Dtls = _MCI.GetCovidAbsentismGrapgh(jsonParam);
response = Request.CreateResponse(HttpStatusCode.OK, CD_Dtls);
}
catch (Exception ex)
{
response = Request.CreateResponse(JsonConvert.DeserializeObject("{\"StatusCode\":\"500\",\"ErrorMessage\":\"" + ex.Message + "\"}"));
}
return response;
}

Class Part Code

public DataTable GetCovidAbsentismGrapgh(JObject jsonParam)
{
CovidInfoDetails CID = new CovidInfoDetails();
object[] ParameterValues = new object[1];
ParameterValues[0] = (string)jsonParam["Company"];
DataTable dt = new DataTable();
try
{
dt = DataAccess.GetDataTable(DBProcedure.GetCovidAbsentismGrapgh, ParameterValues);
}
catch (Exception ex)
{
}
return dt;
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep kumar5y ago
Please tell me ,I need this way[ [],[],[] ]

[
[
"CDate": "19-May",
"Covid +ve": 21.0,
"Quarantine": 13.0,
"In Hospital": 13.0
],
[
"CDate": "20-May",
"Covid +ve": 10.0,
"Quarantine": 0.0,
"In Hospital": 0.0
],
[
"CDate": "21-May",
"Covid +ve": 24.0,
"Quarantine": 52.0,
"In Hospital": 16.0
]
]
+1
Sandeep kumar5y ago
Actually I want in Array Form
+1
Sandeep kumar5y ago
yes,Actually i need in this form
[
{
"CDate": "19-May",
"Covid +ve": 21.0,
"Quarantine": 13.0,
"In Hospital": 13.0
},
{
"CDate": "20-May",
"Covid +ve": 10.0,
"Quarantine": 0.0,
"In Hospital": 0.0
},
{
"CDate": "21-May",
"Covid +ve": 24.0,
"Quarantine": 52.0,
"In Hospital": 16.0
},
{
"CDate": "22-May",
"Covid +ve": 0.0,
"Quarantine": 0.0,
"In Hospital": 0.0
},
{
"CDate": "24-May",
"Covid +ve": 2.0,
"Quarantine": 4.0,
"In Hospital": 2.0
},
{
"CDate": "25-May",
"Covid +ve": 123.0,
"Quarantine": 121.0,
"In Hospital": 143.0
}
]
+1
Sachin Singh5y ago
so, do you want to remove \r\n?
+1
Sandeep kumar5y ago
As Per code ,Result Showing like this

"[\r\n {\r\n \"CDate\": \"19-May\",\r\n \"Covid +ve\": 21.0,\r\n \"Quarantine\": 13.0,\r\n \"In Hospital\": 13.0\r\n },\r\n {\r\n \"CDate\": \"20-May\",\r\n \"Covid +ve\": 10.0,\r\n \"Quarantine\": 0.0,\r\n \"In Hospital\": 0.0\r\n },\r\n {\r\n \"CDate\": \"21-May\",\r\n \"Covid +ve\": 24.0,\r\n \"Quarantine\": 52.0,\r\n \"In Hospital\": 16.0\r\n },\r\n {\r\n \"CDate\": \"22-May\",\r\n \"Covid +ve\": 0.0,\r\n \"Quarantine\": 0.0,\r\n \"In Hospital\": 0.0\r\n },\r\n {\r\n \"CDate\": \"24-May\",\r\n \"Covid +ve\": 2.0,\r\n \"Quarantine\": 4.0,\r\n \"In Hospital\": 2.0\r\n },\r\n {\r\n \"CDate\": \"25-May\",\r\n \"Covid +ve\": 123.0,\r\n \"Quarantine\": 121.0,\r\n \"In Hospital\": 143.0\r\n }\r\n]"
+1
Sachin Singh5y ago
JsonConvert easily serialize the datatable to json
var CD_Dtls = _MCI.GetCovidAbsentismGrapgh(jsonParam);
string json = JsonConvert.SerializeObject(CD_Dtls, Formatting.Indented);
response = Request.CreateResponse(HttpStatusCode.OK,json );
+1