how to insert Html content from Web API to a Datatable

Hi friends,

I am getting the following response from the Web API.

"Name","Invoice Number","Invoice Date","Amount","Tax","Total Amount","Transaction Type"

"user","1000108","2020-02-20 16:46:36","16696.00","500.00","17196.00","SALE"

"user1","1000109","2020-02-22 16:28:58","6767.00","202.00","6969.00","SALE"

It is not in the json format.I am splitting content with the commas like this

var content = response.Content.ReadAsStringAsync().Result;

List obj = content.Split(',').ToList();

in the list it is not getting the name and value simply it is showing indivitual values.

I checked with the

DataTable obj = JsonConvert.DeserializeObject(content);

List> obj = Newtonsoft.Json.JsonConvert.DeserializeObject>>(content);

but getting conversion error

Please tell me how to insert the values into the data table.

2 Replies

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