DataTable adding column doesn't add row?

Question

I need a bit of a steer on this DataTable concept. I'm storing data in a DataTable which I initialise by first adding a column like so:

DataTable outputData = new DataTable();
outputData.Columns.Add("Reference/Group");

Now if I write this out to a CSV file (using my own class), I get what you'd expect, a view in spreadsheet software like:

             A
 1    Reference/Group

Yet when I go on in my script to assume that row 1 exists (by referencing outputData.Rows[0]) I get:

Exception: There is no row at position 0.

However if I try to add a row with the above content, it complains there's no column. If I specify the column then add a row, I can reference Rows[0] but by then I've got TWO rows like:

             A
 1    Reference/Group
 2    Some new row

What's the correct approach here and what is the reason for this behaviour?

Doan Cuong · Accepted Answer · 2013-04-03 09:32:46Z

5

You should use

outputData.Columns[0].ColumnName

instead of

outputData.Rows[0]

Because outputData.Columns.Add("Reference/Group"); will not generate new row for you. And you are using column name for A1 cell, not row data

edited Apr 3, 2013 at 9:32

answered Apr 3, 2013 at 9:26

Doan Cuong

2,6244 gold badges26 silver badges40 bronze badges

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

Comments

Grzegorz W · Accepted Answer · 2013-04-03 09:28:41Z

1

All this says is that your custom "export" code displays column name in first CSV row. It has nothing to do with the actual data inside DataTable. There are in fact 0 rows in Your table before you insert any of them.

answered Apr 3, 2013 at 9:28

Grzegorz W

3,5291 gold badge24 silver badges23 bronze badges

Collectives™ on Stack Overflow

DataTable adding column doesn't add row?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related