Answer / 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

Answer / ganesh

Create appropriate provider at run time(use factory
patterns) based on some configurations setting (probably a
XML file).This will allow user to decide providers
dynamicallly and enable connecting to whatever database he
wants

Answer / 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;
}
}

Answer / suresh jayaraman

<configuration>
<appSettings>
<add key="AccessDatabase" value="Data
Source=servername;Initial
Catalog=databasename;uid=userid;pwd=password"/>
<add key="SqlServerDatabase" value="Data
Source=servername;Initial
Catalog=databasename;uid=userid;pwd=password"/>
</appSettings>
</configuration>

and use this Key name where it is needed

If you need SqlServer DataBase

using System.Data.SqlClient;

in DataAcess Layer


public SqlConnection Connection()
{
try
{
con = new SqlConnection
(ConfigurationManager.AppSettings
["SqlServerDatabase"].ToString().Trim());

return con;

}
catch (Exception exp)
{
throw exp;
}
}

What are the classes in System.Data.Common Namespace?

0 Answers  

---

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   Honeywell,

---

How will you fill the gridview by using datatable object at runtime?

0 Answers  

---

List the 4 common ado.net namespaces?

0 Answers  

---

How to retrieve the user id which is provided while windows authentication?

0 Answers   Cap Gemini,

---

Explian About DataAdapters

0 Answers   BirlaSoft,

---

What is linq and entity framework?

0 Answers  

---

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

0 Answers   Infosys, Wipro,

---

What are the steps in connecting to database?

3 Answers   IBM, Microsoft,

---

What are basic methods of dataadapter?

0 Answers  

---

Explain the role of data provider in ado.net?

0 Answers  

---

What is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?

3 Answers   Fulcrum Logic, Merrill Lynch,

---