Adding new row to datatable's top

Question

When we use datatable.newrow command, a new empty row added to bottom of rows. However I want newrow to added to top of datatable. How can I make it?

Nick DeVore · Accepted Answer · 2011-03-18T17:52:06.187

82

You use the NewRow to create a row with the same columns. To actually get it into the DataTable, you've got to do

myDataTable.Rows.InsertAt(myDataRow, 0);

Where 0 is the index you want to insert it at.

edited Mar 18 '11 at 17:52

answered Dec 03 '08 at 16:41

Nick DeVore

5

myDataTable.Rows.InsertAt(myDataRow,0); is the correct form. Thanks – mavera Dec 03 '08 at 16:50

score 25 · Answer 2 · answered May 05 '16 at 12:40

25

Here is the best example to add row in table

DataRow newRow = myDataTable.NewRow();
newRow[0] = "0";
newRow[1] = "Select one";
myDataTable.Rows.InsertAt(newRow, 0);

It's set the row on first

answered May 05 '16 at 12:40

Sunil Acharya

1

Thank you, this is a little more helpful than the accepted answer – Cory Baumer Jun 12 '18 at 19:30
@CoryBaumer Ohh its my pleasure to... :) – Sunil Acharya Aug 08 '18 at 07:21

score 3 · Answer 3 · edited Sep 27 '11 at 19:34

3

This One is Wrong

myDataTable.Rows.InsertAt(0,myDataRow);

Please use the below line instead of that

myDataTable.Rows.InsertAt(myDataRow,0);

edited Sep 27 '11 at 19:34

CoolBeans

answered Jul 22 '10 at 13:44

Ksamy

4

I have written correct form as a comment of accepted answer. You can see it above. – mavera Jul 26 '10 at 05:34

3 Answers3