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 is autopostback true?

0 Answers  


Define state managenent?Descibe state managenent technique which maintain the information at server site focusing it IDS features and limitations?

1 Answers  


what is PostBack Property exactly ? when It Returns True? when it Returns False?

1 Answers  


what is asp and asp.net ?

2 Answers   Inspira Technologies,


List down the sequence of methods called during the page load.

0 Answers  


Can a master page have more than one contentplaceholder?

0 Answers  


on modify statement, executeNonQuery returns zero rows affected even though there has been modification carried out sucessfully in the table.. can anyone tell me is this possible??? if yes, how..???

1 Answers   ADITI,


What is the difference between control and component?

4 Answers  


For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this?

2 Answers   Microsoft,


What is ViewState and How it is managed,Its Advantages/Benefits?

4 Answers   Google,


In SP has contains 10 query,By Using Dataset Object I need to fetch 8th query of records? How?

5 Answers  


Can you explain why it is useful to use mvc instead of webforms? : asp.net mvc

0 Answers  


Categories