By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,644 Members | 2,423 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,644 IT Pros & Developers. It's quick & easy.

Updating multiple Tables

P: n/a
What is the best/easiest way to update multiple tables at a time?

Can you recommend any tutorials?

Thanks, Justin.

Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Justin
What is the best/easiest way to update multiple tables at a time?

I guess you mean tables in a database....

It depends on how you access your data.

a) DataSet: you can load multiple tables to a dataset add relations to them
(just like in the db) and call the dataadapter.Update() to update multiple
tables.

b) DataReader/Command: You have to fire each sqlcommand yourself.

c) ORM: Just load the objects change them call object.Update() or
objectmanager.Save()
So the question is: where are u?

--
Daniel Fisher(lennybacon)
MCP ASP.NET C#
Blog: http://www.lennybacon.com/


Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.