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?

Answers were Sorted based on User's Feedback



I have one .Net application and i have two databases which is in SQL server2000 and one more databa..

Answer / 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

I have one .Net application and i have two databases which is in SQL server2000 and one more databa..

Answer / shrawan

THROUGH IMPLEMENTING LINKED SERVER

Is This Answer Correct ?    0 Yes 0 No

I have one .Net application and i have two databases which is in SQL server2000 and one more databa..

Answer / sharifuddin

Can u explain how we do with "THROUGH IMPLEMENTING LINKED
SERVER"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

What does asax stand for?

0 Answers  


Features of a dataset ?

3 Answers   Accenture,


What is HTTPModule and HTTPcontext? What is the use of each?

0 Answers   Accenture,


Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?

2 Answers   Siebel Systems,


What is Master Page in Asp.net?

9 Answers  


To call a Web service which transport protocol you can use?

3 Answers   Siebel,


Difference between Active Exe and Activex dll ?

1 Answers   DELL,


IS IT POSSIBLE TO SET TIME FOR COOKIES?HOW IT IS POSSIBLE.

1 Answers  


How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode ?

0 Answers   Microsoft,


how to retrieve property settings from xml .config file.

0 Answers  


List the asp.net validation controls?

0 Answers  


How do you enable tracing? a) Set the Trace property of the Web Form to True b) Set the Trace property of the server object to True c) Set the Session variables Trace to True d) Set the Applications Variable Trace to True.

2 Answers   Syntax Softtech,


Categories