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?
- 4 Answers
- 8846 Views
- Honeywell, I also Faced
- E-Mail Answers
Answer Posted / koteswara rao.chava
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
Get_Conn("TSQL");
//Get_Conn("ACCESS");
//Get_Conn("ORACLE");
}
protected void Get_Conn(string con_condition_Str)
{
switch (con_condition_Str)
{
case ("ACCESS"):
//SET CON = access constring
break;
case ("TSQL"):
// SET CON = SQL SERVER constring
break;
case ("ORACLE"):
// SET CON = ORACLE constring
break;
}
}
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you update database through dataset?
What is ado.net architecture?
What are the benefits of using of ADO.NET in .NET 4.0?
What is sqldatasource?
What is the namespaces being used to access oracle database?
How do you update a dataset in ado.net?
What is a column variable?
What is the use of SqlCommand object?
Explain the role of data provider in ado.net?
What is ole word?
Why do we serialize data?
What are all the classes that are available in System.Data Namespace?
What is a string variable?
What is untyped dataset?
Can we connect two dataadapters to same data source using single connection at same time?
