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 is the meaning of executenonquery?

0 Answers  

---

Explain the advantages and disadvantages of using datalist?

0 Answers  

---

ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?

3 Answers   Zensar,

---

what are the two key events for the sql connection class? explain the differnce between the two.

2 Answers   HCL, NIIT, Zensar,

---

What are all the commands used with Data Adapter?

0 Answers  

---

What is ado and dao?

0 Answers  

---

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

0 Answers  

---

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

0 Answers  

---

What is two way data binding android?

0 Answers  

---

How do you update database through dataset?

0 Answers  

---

What is read only and forward only in ado.net?

0 Answers  

---

What is variable view?

0 Answers  

---