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 |
How do you sign out from forms authentication?
About friend and Protected friend ?
How to disable validator control by client side JavaScript?
What New Features comes with ASP.NET Web API 2.0?
How many webforms are possible on a single webpage?
How can we apply themes to an asp.net application?
if i have 1000 records and i want to access 20 ata time from SQL server, what will be the query?
What is the adavantage of using ASP.NET routing?
How do cookies work?
Fetch one page value to another page without using state-managment ?
What base class do all Web Forms inherit from?
Difference between ASP & ASP.NET Session State
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)