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 / 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 can we add relation between tables in a dataset?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
Explain the difference in record set and dataset?
How to connect and retrieve data from database using dataset
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
How to pass multiple tables in datasets simultaneously?
What is the provider being used to access oracle database?
Which is the feature of ado.net?
What are good ado.net object to replace to ado recordset object.
What is the difference between executenonquery () and executescalar ()?
Which is faster dataset or datareader?
What is meant by executenonquery?
What are two important objects of ADO.Net?
How to identify the updated rows in a dataset?
Give an example that shows how to execute a stored procedure in ado.net?