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
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 |
Answer / sharifuddin
Can u explain how we do with "THROUGH IMPLEMENTING LINKED
SERVER"
| Is This Answer Correct ? | 0 Yes | 0 No |
What does asax stand for?
Features of a dataset ?
What is HTTPModule and HTTPcontext? What is the use of each?
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?
What is Master Page in Asp.net?
To call a Web service which transport protocol you can use?
Difference between Active Exe and Activex dll ?
IS IT POSSIBLE TO SET TIME FOR COOKIES?HOW IT IS POSSIBLE.
How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode ?
how to retrieve property settings from xml .config file.
List the asp.net validation controls?
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.
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)