Datatable values to datagridview, only showing one columns data

Question

I have a datatable filled with a report from a web service. I am now trying to display the datatable in an datagridview. This is the code I use to build the datatable:

// Create DataTabe to handle the output
DataTable dt = new DataTable();

dt.Clear();
dt.Columns.Add("EmployeeFirstName");
dt.Columns.Add("EmployeeLastName");
dt.Columns.Add("DepartmentName");
dt.Columns.Add("DepartmentCode");
dt.Columns.Add("LocationName");
dt.Columns.Add("DivisionCode");
dt.Columns.Add("EarningName");
dt.Columns.Add("OTHours");
dt.Columns.Add("WorkDate")

Fill the new datatable:

foreach (ReportRow row in report.Rows)
{
  dt.Rows.Add(string.Join(",", row.ColumnValues));
}

Then I try to bind the data in the datatable to the dataGridview:

dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = dt;
dataGridView1.Refresh();

When I run the application it only displays the data from the first column in the datatable. Do I need a loop of sorts to work through the columns or am I just missing a step?

Rahul Rahul · Accepted Answer · 2016-08-03T19:24:05

Yes that's cause you are adding only one value to your dt when you say dt.Rows.Add(string.Join(",", row.ColumnValues));. You should be doing something like below (assuming that ReportRow also has the columns with same names like "EmployeeFirstName" else change the names accordingly)

foreach (ReportRow row in report.Rows)
{
  DataRow dr = dt.NewRow();
  dr["EmployeeFirstName"] = row["EmployeeFirstName"];
  dr["EmployeeLastName"] = row["EmployeeLastName"];
  dr["DepartmentName"] = row["DepartmentName"];
  //rest of the columns fill

//once all columns filled
dt.Rows.Add(dr);
}

Datatable values to datagridview, only showing one columns data

3 Answers