Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

What is application Object?

991


What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.

985


What is diff. Between abstract class and an interface?

978


In early binding will the method invoked on com component will verify it?s existance in the system or not ?

2582


What are the advantages of asp.net mvc framework? : asp.net mvc

975


What is Dynamic Web and discuss its usage with the help of real life examples?

994


Is it possible to apply themes to an asp.net application? If yes, then how?

975


What are the features of asp.net mvc?

961


Describe the application event handlers in ASP.NET?

997


How Session outproc in Sqlserver stored?

2717


Can the unique key be null?

1035


Explain the function of new view engine in asp.net? : asp.net mvc

969


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?

868


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

2298


What is the request flow used for asp.net mvc framework? : asp.net mvc

931