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

How can you apply a theme to your asp.net application?

0 Answers  


What is a DLL Hell Problem in .Net?

12 Answers  


For which does this Codebehind="MyCode.aspx.cs" is relevent to ?

0 Answers   Siebel,


witch is the best insistute in sharpoint course.what abt future of share point course.

2 Answers  


What is meant by web application?

0 Answers  


WHAT ARE DEFFERENCE BETWEEN DATALIST AND DATAGRID

1 Answers   Seion Infotech,


What is the difference between typeof() vs gettype()?

0 Answers  


What is the < machinekey > element and what two ASP.NET technologies is it used for ?

1 Answers  


What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

4 Answers  


Whats an assembly

2 Answers   IBM,


You have been given the task of designing a web services to expose the data that is stored in a database on the server. In order to successfully build the web services, you need to import some namespaces. What is the minimum namespace you need to import? a) System.Web b) System.WebServices c) System.Web.Services d) System.Web.ServiceModel

2 Answers   Syntax Softtech,


What are the various authentication mechanisms in ASP.NET ?

1 Answers   Digital GlobalSoft, Satyam,


Categories