array of strings into a DataGridView in C#

Question

I'm reading each line of a file into an array of strings:

string[] lines = File.ReadAllLines(filePath);

Each line is separated by a tab

lines[0] = "John\tPizza\tRed\tApple"

I want to load this string array into a DataGridView. I tried the following:

DataTable dt = new DataTable();
dt.Columns.Add("Name",typeof(string));
dt.Columns.Add("Food",typeof(string));
dt.Columns.Add("Color",typeof(string));
dt.Columns.Add("Fruit",typeof(string));

foreach(string s in lines)
{
   dt.Rows.Add(s);
}

myDataGridView.DataSource = dt;

The problem is that all the strings are loaded to the first column of the DataGrid:

I need them to be separated like this:

You need to split each line by that delimiter, and then add each of those split values to each column for each row, instead of dt.Rows.Add(s); — devlin carnate
– devlin carnate, Commented Jun 21, 2022 at 19:28

Brook Stang · Accepted Answer · 2022-06-21 19:49:08Z

2

You will need to split the lines on the tab. Here is an example:

foreach (string s in lines)
{
   var splitLine = s.Split("\t");
   dt.Rows.Add(splitLine);
}

I also found some documentation that says you need to create a new row with the NewRow() method and then fill out each column value. Here is what that would look like:

foreach (string s in lines)
{
   // Split the line
   var splitLine = s.Split("\t");

   // Create the new row
   var newRow = dt.NewRow();
   newRow["Name"] = splitLine[0];
   newRow["Food"] = splitLine[1];
   newRow["Color"] = splitLine[2];
   newRow["Fruit"] = splitLine[3];

   // Add the row to the table
   dt.Rows.Add(newRow);
}

answered Jun 21, 2022 at 19:49

Brook Stang

762 bronze badges

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

Collectives™ on Stack Overflow

array of strings into a DataGridView in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related