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 is @@rowcount and with small code snippet explain the usage?

4 Answers   BirlaSoft,

---

What is the use of parameter object?

4 Answers   CDC, Ksb,

---

What is ado.net full form?

0 Answers  

---

What is Debug.write does?

1 Answers  

---

What is method to get XML and schema from Dataset? getXML() and get Schema ()

0 Answers  

---

About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?

1 Answers   MMTS,

---

What is ado or jdbc?

0 Answers  

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

0 Answers  

---

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

---

What is Dataset Object?

0 Answers  

---

What is ole word?

0 Answers  

---

What is an ado?

0 Answers  

---