DataTable.Rows.InsertAt won't accept new object[] where DataTable.Rows.Add does

Question

I feel like I must not be doing something right here. I have a DataTable and it's currently able to take my arguments using the DataTable.Rows.Add method, but when I use DataTable.Rows.InsertAt it throws an error

What I'm currently doing with no issues:

dt.Rows.Add(new object[] { txtCompID.Text, scan(TrimStart('0'), txtEtaNum.Text, txtBinLocation.Text });

What I want to do (so the insert happens at the top), which is throwing "Argument 1: Cannot convert from 'object[]' to 'System.Data.DataRow'"

dt.Rows.InsertAt(new object[] { txtCompID.Text, scan.TrimStart('0'), txtEtaNum.Text, txtBinLocation.Text }, 0);

Can you tell me why you want it inserted at the top? What's the driver for that? — Mike Perrenoud
– Mike Perrenoud, Commented Sep 27, 2012 at 18:33
@Blam, nope the reason it can't be done is because InsertAt requires a data row to be passed to it. — Mike Perrenoud
– Mike Perrenoud, Commented Sep 27, 2012 at 18:35
DataRow.Add has two Overloads one takes an object which you are using the other takes a DataRow. DataRow.InsertAt only has the DataRow Method. — Mark Hall
– Mark Hall, Commented Sep 27, 2012 at 18:42
Thanks everyone for the input. It was most definitely that InsertAt only has one overload. I was able to create a new DataRow to do this. — Tom
– Tom, Commented Sep 27, 2012 at 18:46

Adil · Accepted Answer · 2012-09-27 18:32:53Z

3

You need to add row in dt that is of type of dt. You can use dt.NewRow() method to get the row for dt. You can do it this way.

DataRow dr = dt.NewRow();

dr[0] = "coldata1";
dr[1] = "coldata2";
dr[2] = "coldata3";
dr[3] = "coldata4";

dt.Rows.Add(dr);

answered Sep 27, 2012 at 18:32

Adil

148k25 gold badges217 silver badges207 bronze badges

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

Comments

Matt Burland · Accepted Answer · 2012-09-27 18:34:54Z

1

InsertAt doesn't support that. See here. You need to construct a DataRow first and then you can insert it.

answered Sep 27, 2012 at 18:34

Matt Burland

45.3k18 gold badges110 silver badges182 bronze badges

Collectives™ on Stack Overflow

DataTable.Rows.InsertAt won't accept new object[] where DataTable.Rows.Add does

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