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 different methods available under the sqlcommand class to access the data?

0 Answers  

---

WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers   Infosys, Wipro,

---

How can you add or remove rows from the datatable object of dataset?

0 Answers  

---

Explain which name space is used to get assembly details?

0 Answers  

---

How to fetch the last inserted record in a particular table?

10 Answers   CarrizalSoft Technologies, Microsoft,

---

What is difference between executenonquery and executequery?

0 Answers  

---

What is an orm, and why would you use one instead of plain old ado.net?

0 Answers  

---

Why do we serialize data?

0 Answers  

---

Explain ado.net features?

0 Answers  

---

What is the difference between a datareader and a dataset?

0 Answers  

---

How many types of data table are in SQL.NET

4 Answers   Chetu India, HCL, MAHINDRA,

---

Explain acid properties?

4 Answers  

---