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?
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 is application Object?
What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.
What is diff. Between abstract class and an interface?
In early binding will the method invoked on com component will verify it?s existance in the system or not ?
What are the advantages of asp.net mvc framework? : asp.net mvc
What is Dynamic Web and discuss its usage with the help of real life examples?
Is it possible to apply themes to an asp.net application? If yes, then how?
What are the features of asp.net mvc?
Describe the application event handlers in ASP.NET?
How Session outproc in Sqlserver stored?
Can the unique key be null?
Explain the function of new view engine in asp.net? : asp.net mvc
Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?
benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks
What is the request flow used for asp.net mvc framework? : asp.net mvc