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
- 6233 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
ASP.NET 2.0's new membership API used for creating and managing user account is exposed through which 2 clause?
How many types of sessions are there in asp net?
What are server activated objects?
How long the items in ViewState exists?
Less than one page, how many windows will you be able to maintain?
What is the function used for removing an event listener?
What is advantage of code behind coding in ASP.NET?
Explain what is event bubbling?
What is scope of an application variable in asp.net?
What is variable and constant in .net programming language?
Why does my asp.net file have multiple tag with runat=server?
What is full form of asp.net?
code for "For every 5days system has to create 1text file with the corresponding date and it has to store in c-drive" by using web applications
Define viewstate in .net?
Define tracing.
