ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
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 Submitted By :: Sharfuddin
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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?
Answer
# 1
THROUGH IMPLEMENTING LINKED SERVER
 
Is This Answer Correct ?    0 Yes 0 No
Shrawan
 
  Re: 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?
Answer
# 2
Can u explain how we do with "THROUGH IMPLEMENTING LINKED
SERVER"
 
Is This Answer Correct ?    0 Yes 0 No
Sharifuddin
 
 
 
  Re: 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?
Answer
# 3
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 ?    2 Yes 0 No
Santosh
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
About the Usage of htmlencode and urlencode ? Cognizent2
How to merge 2 tables fields in DataTable in asp.net Wipro5
how can we maintain security in soted procedure?  1
Is object a value type or referenced type?  2
Difference between .NET and previous version? Microsoft1
hi i have a problem regarding to datagrid in aspdotnet.i have a datagrid in my application.i have to place add,edit,delete buttons or links what ever it may be. now the problem is if i click on add button then the page has to redirected to another form called "xyz.aspx" and if i click on edit button the page has to redirected to another form called "abc.aspx".i am phasing the problem that if where ever i click on the datagrid the cursor goes to gv1_SelectedIndexChanged event.please tell me the solution about the code. Lambent4
In C#.net application is run on linux michine  3
How to Page Execute in asp.net(inside browser) Wipro1
When during the page processing cycle is ViewState available?  1
What type of code (server or client) is found in a Code-Behind class?  1
all asp.net interives questions  1
How to do Forms authentication in asp.net?  2
How do you implement postback with a text box? What is postback and usestate?  1
when using windows API in .net then it is managed code or Unmanaged code?  1
Contrast the use of an abstract base class against an interface? iLink4
How to kill more than one session variables at a time iSoft6
What is boxing? How we can use it? NIIT2
Way of updating a table other than stored procedure and hard coded query?  2
Finally and dispose methods? Microsoft1
What are the 4 tenants of SOA/D.  1
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com