Loading

manipulate two different database using c#

mvp ram

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
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