Answer Posted / srinivas.kinthada

i think it's oledb may b.

in c#.net coding

1)
using oledd provider
1.system.data.oledb;
2.oledbconnection cn=new
oledbconnection("username=<username>;pwd=<password>;server=<servername>");
3.cn.open();

2)
using orcale provider
1.first u can give in u r application reference of
system.data.orcaleclient.dll file trough solutionexplorer of
u r application
(rt click the mouse--->over solutinexplorer--->and click add
reference--->click on project---> and select
system.data.orcaleclient.dll file--->ok )
2.using system.data.orcaleclient;
3.orcaleconnection cn=new
orcaleconnection("username=<username>;pwd=<password>;server=<servername>");
3.cn.open();

What is the default Timeout for SqlCommand.CommandTimeout property?

510

---

What are the different execute methods of Ado.Net?

553

---

Is ado.net dead?

540

---

What are the steps you will take to improve performance?

463

---

How can we perform transactions in .net?

545

---

---

Explain the difference between an ado.net dataset and an ado recordset?

535

---

Is it possible to load multiple tables in a Dataset?

530

---

What is linq and entity framework?

515

---

What are the ado.net components?

527

---

What is executenonquery ado.net?

497

---

how Sequence to connect and retrieve data from database using dataset?

754

---

How does ado.net work?

494

---

What are typed and untyped dataset?

557

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

528

---

List the 4 common ado.net namespaces?

699

---