Interested to Buy Any Domain ? << Click Here >> for more details...
I have one .Net application and i have two databases which
is in SQL server2000 and one more database in ORACLE? how
can i access the database from different Databases?
- 3 Answers
- 6807 Views
- eXensys, I also Faced
- E-Mail Answers
Answer Posted / santosh
Use
DATASET for that
just take 2 conenctions
one with Sql server and other with Oracle
then use
OledbDataAdopter DAD1 = new Oledbdataadopter("select * from
emp",SQL Serverconnection)
OledbDataAdopter DAD2 = new Oledbdataadopter("select * from
Student",Oracle)
then
DAD1.fill(Dataset,"emp");
DAD2.fill(dataset,"student");
now u can acces data from same Dataset
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are Session states available and its Uses?
Can I have a unique key as foreign key?
How do I debug an asp.net application that was not written with visual studio.net and that does not use code-behind?
How will you load dynamic assembly?
What is cas?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
How to change Master page in ASP.Net using code?
In which event of page cycle is the viewstate available?
How ASP and ASP.NET page works? Explain about asp.net page life cycle?
Describe paging in asp.net?
How many languages are supported by .NET at present time?
5. What three Specific Job Positions do you target from Swatz Oils GROUP U.K?
Why do we use datasource in asp.net?
Is global asax mandatory?
How can we add an event handler for a ASP.NET function executed on MouseOver for a certain button.
