1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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?

Question Posted / sharfuddin

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 Page.IsValid in asp.net

6 Answers   Infosys, Net Solution,

5. What three Specific Job Positions do you target from Swatz Oils GROUP U.K?

0 Answers   Swatz Oils,

What is postback and autopostback in asp.net?

0 Answers  

How to disable SOAP1.2 in Web Services?

1 Answers  

Explain the difference between or and orelse?

0 Answers  




What is break mode?

0 Answers  

What is ascx?

0 Answers  

What is work flow gen? how can it will work with .Net?

0 Answers   TCS,

Can we make activex dll also ti execute in some process as that of client ? How can we do?

0 Answers   DELL, Zerone,

Explain the Session state management options available with ASP.NET?

0 Answers   Siebel,

What type of code (server or client) is found in a Code- Behind class?

2 Answers  

How do we implement bundling in MVC?

0 Answers   B-Ways TecnoSoft,

For more ASP.NET Interview Questions Click Here
Categories