exception while adding multiple rows to datatable. Couldn't store <System.Data.DataRowCollection>

Question

idLocals is Primary key in database

Populating the datatable

oDtLocalCharge = bll.GetData();

i am copying the datatable in another function

   dtLocalCharges = oDtLocalCharge.Copy();

and trying to add rows using below code

DataRowCollection drr = oDtLocalCharge.Rows;
dtLocalCharges.Rows.Add(drr);

When i try to add rows to datatable, i am getting error as below

Error: 
{System.ArgumentException: Unable to cast object of type 'System.Data.DataRowCollection' to type 'System.IConvertible'.Couldn't store <System.Data.DataRowCollection> in idLocals Column.  Expected type is Int32. ---> System.InvalidCastException: Unable to cast object of type 'System.Data.DataRowCollection' to type 'System.IConvertible'.

May be Primary Key idLocalsis causing problem what is the problem?

How can i fix this? I want to multiple add rows in dtLocalCharges table

Ray Henry · Accepted Answer · 2010-10-06 14:56:32Z

4

First off, you can't use Add() with a DataRowCollection. You need to add each row individually. You will probably need to use NewRow, copy the values and then call Add.

Try this first:

DataRowCollection drr = oDtLocalCharge.Rows;
foreach (var row in drr) dtLocalCharges.Rows.Add(row);

answered Oct 6, 2010 at 14:56

Ray Henry

9056 silver badges12 bronze badges

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

1 Comment

Ray Henry Over a year ago

Good one! I didn't look at the entire DataTable API.

Mischa · Accepted Answer · 2012-11-02 07:05:13Z

1

This is the best way to import all rows of one datatable into another datatable:

datatable1.Load(New DataTableReader(datatable2))

edited Nov 2, 2012 at 7:05

Mischa

43.4k9 gold badges101 silver badges111 bronze badges

answered Nov 2, 2012 at 6:48

nizam ansari

111 bronze badge

Collectives™ on Stack Overflow

exception while adding multiple rows to datatable. Couldn't store <System.Data.DataRowCollection>

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related