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 is the difference between ASP Session State and ASP.Net Session State?
What is tracing? Where is it used?
Can we have 2 web config files?
Describe the difference between inline and code behind.
why many web.config files are used in are project
Explain difference betn dataset and recordset?
What is the difference between CC and BCC?
Explain diff. Betn dataset and recordset?
Describe the sequence of action takes place on the server when ASP.NET application starts first time?
How you can stop the validation of ASP.NET controls from client side?
0 Answers Sans Pareil IT Services,
What is use of Master Page in ASP.NET web pages?
0 Answers Sans Pareil IT Services,
Explain Optimization technique description?