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 |
We have 2 sites in which one site allows the user with out asking credentials and second one ask for credentials through a log page. What might be the configurations settings for both sites? We can use IIS and web.config files together.
Define application state variable and session state variable?
What is DataGrid wheater its a Server Control or something else ?
If you want to bind the columns manually within the asp:datagrid tags what kind of tags you have to add.
I have got less marks in bsc it So how to get interview.tell me
What is viewstate? What does the “enableviewstate” property do?
Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process?
1 Answers Patni, Perot Systems, Sedna Technology,
What is the use of session?
Which namespace is used by ado.net?
About Usage of server variables ?
What is difference between user control and custom control?
Differences between session state and Application 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)