ArgumentException when adding rows from DataGridView to DataTable

Question

I'm fairly new to C# programming. I want to take user input from DataGridView to a DataTable. However, I get ArgumentException from this code

DataTable dd=new DataTable();
       foreach (DataGridViewRow dr in dataGridView1.Rows)
       {
           dd.Rows.Add(dr);
       }

Is there any way I can do to fix it? I'd like to have alternatives to get input from dataGridView1 as well.
edit: forgot to mention, dataGridView1 has one comboBox column.
edit2: the error read "Input array is longer than the number of columns in this table."

Dzienny · Accepted Answer · 2015-07-04 07:13:56Z

1

Input array is longer than the number of columns in this table.

You have to add a column to DataTable eg: dd.Columns.Add("SomeColumnName"), before you add rows to it.

However, if there's no particular requirement to use DataTable then you should use, for example, List to store the rows. It is a much simpler data structure.

var listOfRows = gridView.Rows.Cast<DataGridViewRow>().ToList();

edited Jul 4, 2015 at 7:13

answered Jul 4, 2015 at 6:58

Dzienny

3,4271 gold badge23 silver badges32 bronze badges

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

1 Comment

Leil Over a year ago

ah, I forgot to mention that i will manipulate the data to show it again in another form, so I think I need DataTable. But thanks for pointing out my mistake!

Collectives™ on Stack Overflow

ArgumentException when adding rows from DataGridView to DataTable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related