manipulate two different database using c#

Question

Hi My question is : i want get the values from different databases ( eg: oracle and sql server) using c#. then i have to manipulate those values from two different databases. Finally i have updated to the those databases. Kindly help me to resolve the issue.

Vijaya Kadiyala · Answer

Hi If you are using ADO.NET then you can have one dataset and two tables which are populated from SQL Server and Oracle. This is one way of doing it. The other option is You can create Linked server in SQL Server to access oracle tables and using ado.net objects to store this information. Please let me know if you have any questions Thanks -- VJ http://dotnetvj.blogspot.com