Best way to add data to database

[saintedmunds]

HI

I have an app that sends out bulk emails from my Database.
So it loops round sending the email and it either succedded or failed.
Now I want to record this info in a database lets say table name EmailCampaignResults FieldNames ContactID CampaignID and Succedded(Bit/True 0r False) now i can do the insert etc but when is best to do this?
If i do it after each send I have to open the database add the data close the database then go on to the next one this seems a very slow and longwinded way.
Would it be better to store the data in an Array or Dataset and then add this to the database after all the sending is complete?

What do you think would be best?

Cheers

 

[ca8msm]

Have a look at the SQLBulkCopy class.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[saintedmunds]

Thank you for the quick reply.

So would I load my data into a datatable in the loop and the use the sqlBulkCopy to updata the database?

Cheers

 

[ca8msm]

Yes, that's correct.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]