converting csv to json using .net and sending json data to iothub

Question

I am trying to convert csv data into json data format.

I wrote code as below. How to convert below data as json format data

string csvData = File.ReadAllText(csvPath);

//Execute a loop over the rows.

foreach (string row in csvData.Split('\n'))
{
    if (!string.IsNullOrEmpty(row))
    {
        dt.Rows.Add();
        int i = 0;
        //Execute a loop over the columns.  
        foreach (string cell in row.Split(','))
        {
            dt.Rows[dt.Rows.Count - 1][i] = cell;
            Console.WriteLine(dt.Rows[dt.Rows.Count - 1][i]);
            i++;
        }
    }
    var telemetryDataPoint = row;
}

Possible duplicate of Converting a csv file to json using C# — MethodMan
– MethodMan, Commented Nov 27, 2017 at 17:59
CSV text files come with so many questions. If you have Excel, go Data»Get External Data»From Text and select a text file. Run through the Text Import Wizard. You should have an answer to every question and put that knowledge into code, as applicable. — Tom Blodget
– Tom Blodget, Commented Nov 27, 2017 at 18:20

Sunil · Accepted Answer · 2017-11-28 14:07:30Z

0

Try this:

foreach (string row in csvData.Split('\n'))
{
  if (!string.IsNullOrEmpty(row))
  {
    string jsonString = new 
System.Web.Script.Serialization.JavaScriptSerializer().Serialize(row); //Per row
    dt.Rows.Add();
    int i = 0;
    //Execute a loop over the columns.  
    foreach (string cell in row.Split(','))
    {
      dt.Rows[dt.Rows.Count - 1][i] = cell;
      Console.WriteLine(dt.Rows[dt.Rows.Count - 1][i]);
      i++;
    }
  }
  var telemetryDataPoint = row;
}

OR

// All at once
var data = (from row in csvData.Split('\n')
            select row.Split(',')).ToList();
string jsonString = new 
System.Web.Script.Serialization.JavaScriptSerializer().Serialize(data);

answered Nov 28, 2017 at 14:07

Sunil

3,44210 gold badges27 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

converting csv to json using .net and sending json data to iothub

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related