Answer / srinivas.kinthada

i think oldb is not correct it's may b.
it is oledb

using system.data.oledb;
oledbconnection cn=new
oledbconnection("uid=<username>;pwd=<password>;server=<servername>");
cn.open();

Answer / raghavendra.v

it is not oldb it may be oledb

using System.Data.Oledb;

Oledbconnection cn=new OleDbConnection
("Provider=Msdaora.1;uid=<username>;pwd=<pwd>;server=<server
name>");
cn.open();

Answer / sudha

first add the namespace

using system.Data.oledb;

OledbConnection cntn = new OledbConnection("Provider =
Microsoft.jet.oledb.12.0;datasource = (local);Integrated
security = SSPI,persistent Security = false");

provider = it depends on version of Microsoft Access like if
it is 2003 - 4.0 & if it is 2007 - 12.0

dataource - u can make it as local or provide the path to ur
database

What are the main differences between classic ado and ado.net?

0 Answers  

---

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers   Wipro,

---

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

---

What do you know about ado.net's objects?

0 Answers  

---

What is difference between entity framework and ado.net?

0 Answers  

---

What is ado oledb and odbc?

0 Answers  

---

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ?

1 Answers   Digital GlobalSoft,

---

Explain the basic use of "dataview" and explain its methods.

0 Answers  

---

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  

---

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

0 Answers  

---

Can we bind one datareader wid two dropdown list?

5 Answers  

---

What is difference between executequery and executeupdate?

0 Answers  

---