sqldataadapter.update() vs sqlbulkcopy class

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

sqldataadapter.update() vs sqlbulkcopy class

Author

Topic

rammohan
Posting Yak Master

212 Posts

Posted - 2009-11-13 : 06:36:02

hi,

which one is efficiant?

either Sqldataadapter.update(datset)

or

using(sqlbulkcopy _c = new sqlbulkcopy(connection))

{

_c.destinationtablename = "x";

_c.writetoserver(datatable)

}

what are the major differences between these two when we r uploading modified dataset or data table values into database at one time?

how to override the exception "unique key excetpion" when we r uloading data by using above two methods into database?

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

rammohan
Posting Yak Master

212 Posts

Posted - 2009-11-16 : 04:10:41

i got the answer,thank u

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-11-16 : 11:04:48

so whats your findings ? please share

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources