ASP.Net - Easy question CSV read comma

Hello all,

I have the following code and the split is finding the extra comma it looks like in the row like this how do I handle this.  File has 9 columns 0-8  Row example:

 

[2]: "AE,1,VARIABLE,ID,SD0058,\"Variable appears in dataset, but is not in SDTM standard\",Metadata,Warning,"

Code is:
  // create new datatable
        DataTable dt = new DataTable();

        // get the column header means first line
        string[] temp = str[0].Split(',');

        // creates columns of gridview as per the header name
        foreach (string t in temp)
        {
            dt.Columns.Add(t, typeof(string));
        }

        // now retrive the record from second line and add it to datatable
        for (int i = 1; i < str.Length; i++)
        {
            string[] t = str[i].Split(',');
            dt.Rows.Add(t);
        }

Select allOpen in new window