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();

Explain the differences between oledb sql server, oledbdotnet provider?

955

---

Which is the best method to get two values from the database?

925

---

Which keyword is used to accept variable number of parameters?

1070

---

What do you mean by performing asynchronous operation using command object?

975

---

Is ado.net an orm?

909

---

What is the use of adodc?

948

---

What are the namespaces used in ADO.Net to connect to a database?

1118

---

What is Serialization in .NET? what are the types of Serialization?

1033

---

How does ado.net work?

874

---

What is variable view?

833

---

How do you connect to sql server database without using sqlclient?

1053

---

How to find the given query is optimised one or not?

922

---

Command objects uses, purposes and their methods.

934

---

What is ado.net architecture?

883

---

What is oledb connection?

940

---