If we want to connect to many databases in dataaccess layer
such as MSAccess,Sql server,oracle means not to a particular
database depends on condition we have to connect to
appropriate database in this scenario if we without changing
code Ho wdo you handle this situation?
Answer Posted / alok saxena
Hey!
You are giving clue in your question.
First We have to use select case option, In each case we
have to use respective database connection,pwd,
Mind you must have to select approrpiate provider e.x. Sql
u must use System.Data.Sql
Wish u a good luck
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Which ado.net object is very fast in getting data from the database?
What is an ado connection?
What does executenonquery () method return?
What is the difference between a datareader and a dataset?
What is the use of data grid?
Explain the overview of ado.net architecture?
How do I delete a row from a DataTable?
What are the advantages of using datalist?
Name which operations can you not perform on an ado.net dataset?
What we do with the object of ado.net dataset after using it?
How many major types of connection objects in ADO.NET?
Which architecture does Datasets follow?
What is connection pooling and what is the maximum pool size in ado.net connection string?
Can we load multiple tables in a dataset?
What is difference between datagridview and datagrid control in winforms?