C# . net+ datatable.importrow

Category: .NET
18 Jun 2009 04:10
Joined: 27/01/2008
Level: Gold
Points: 557
Points: 1
C# . net+ datatable.importrow
hi,
i wnat to impoet rows from a datatable but not affecting tae datatable.
can i perform datarow copy or clone?

thanks
#391146
18 Jun 2009 04:13
Joined: 16/06/2006
Level: Gold
Points: 14847
Points: 2
Hi,

Do you want to copy a row from one table to another table?

Regards
JK
Thanks & Regards
D.Jeya Kumar(JK)
#391151
18 Jun 2009 04:18
Joined: 05/06/2009
Level: Gold
Points: 4736
Points: 2
Hi,

Use ImportRow to import rows from another table

** You can use DataTable.Load method to load data from a IDataReader
object, which can be created through DataTable.CreateDataReader

Also when load data into datatable, you should call BeginLoadData,
EndLoadData so as to turn off event notification(improve performance
Regards

VIJI RAJKUMAR
Pls rate my Answer if it was supportive
http://vijirajkumar.blogspot.com

Joined:	27/01/2008
Level:	Gold
Points:	557

Points:	1

Joined:	16/06/2006
Level:	Gold
Points:	14847

Joined:	05/06/2009
Level:	Gold
Points:	4736

#391155

18 Jun 2009 04:22

Joined:	16/06/2006
Level:	Gold
Points:	14847

Points:	2

Hi,

check the below sample code. it might help you or give you an idea to use the import row


//Fill the datatable before using the sample code
datatable dtNodeGridLoadFiles = new datatable(); 
    foreach (DataRow drOnGrid in dtOnGrid.Rows) { 
        if ((drOnGrid != null)) { 
            if (drOnGrid .Length > 0) { 
                dtNodeGridLoadFiles.ImportRow(drOnGrid); 
            } 
        } 
    }

Regards
JK

Thanks & Regards
D.Jeya Kumar(JK)

#391165
18 Jun 2009 04:30
Joined: 27/01/2008
Level: Gold
Points: 557
Points: 2
hi,
Thanks for yur reply. but . in this way the row is imported form the datatable . while there is no datarow in the original datatable how can i solve the problem .

i need to copy datatable with same data and structure but when i make change in copy there is change in original datatable. how can i copy datatble in the way thet oriiginal and copy doesnot get affected by the changes in other.
#391250
18 Jun 2009 05:20
Joined: 15/11/2006
Level: Silver
Points: 223
Points: 2
DataTable dtNew = new DataTable();
dtNew.Merge(dtOrginal);

if u make any chnages in dtNew table, it will not effect to the dtOrginal.

Regards
Raaj

Joined:	15/11/2006
Level:	Silver
Points:	223

C# . net+ datatable.importrow

Email subscription