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 autopostback true?
Define state managenent?Descibe state managenent technique which maintain the information at server site focusing it IDS features and limitations?
what is PostBack Property exactly ? when It Returns True? when it Returns False?
what is asp and asp.net ?
2 Answers Inspira Technologies,
List down the sequence of methods called during the page load.
Can a master page have more than one contentplaceholder?
on modify statement, executeNonQuery returns zero rows affected even though there has been modification carried out sucessfully in the table.. can anyone tell me is this possible??? if yes, how..???
What is the difference between control and component?
For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this?
What is ViewState and How it is managed,Its Advantages/Benefits?
In SP has contains 10 query,By Using Dataset Object I need to fetch 8th query of records? How?
Can you explain why it is useful to use mvc instead of webforms? : asp.net mvc