Answer / govind.konduri

using system.data.oledb;

oledbconnection oracon=new oledbconnection
( " provider=msdaora;
User Id=scott;
Password=Tiger");

Answer / kakani kumar

Using System.Data.Oledb;

OledbConnection cnn = new Oledbconnection("Prvider=MsDaOra,
User ID=scott, Password=Tiger, Datasource=m10 );
Datasource is optinal

Answer / srinivas

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

here u declare <user_name> is u give username
pwd is u give password
<server> or data source is u give

Answer / sinthu vijay kumar

hi friends...

we have so many databases for ex oracle,sql
server,sybase,ms Access etc.providers are used to giving
the connecion to the database ,which r different for
different databases.the avilable providers in ado.net are
oracle.net data provider,odbc.net dataprovider etc.
the syntax for provider is:
con=new odbcconnection
("uid=scott,pwd=tiger,database=oracle")
here uid,pwd,database r vary with different databases.

Answer / sinthu vijay kumar

hi friends...

we have so many databases for ex oracle,sql
server,sybase,ms Access etc.providers are used to giving
the connecion to the database ,which r different for
different databases.the avilable providers in ado.net are
oracle.net data provider,odbc.net dataprovider etc.
the syntax for provider is:
con=new odbcconnection
("uid=scott,pwd=tiger,database=oracle")
here uid,pwd,database r vary with different databases.

Answer / siddhartha sharma

using System.data.oledb;
oledbdataadapter da;
dataset ds;
da=new data Adapter("select * from
Databasename","connection string");
ds=new dataset();
da.fill(ds);// fetch the database to frontend
//// we use that syntex to fetch oracle database to our
application

How to check if the Dataset has records ?

0 Answers   NA,

What is difference between sqldatareader and sqldataadapter?

0 Answers  

What is ado recordset?

0 Answers  

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,

What is ado connection?

0 Answers  

What is the difference between data grid and data repeater?

0 Answers  

What are the 3 major types of connection objects in ado.net?

0 Answers  

What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

0 Answers   Infosys, Wipro,

What is a datagridview?

0 Answers  

What's the difference between Dataset.clone and Dataset.copy?

10 Answers   Ksb,

What are the different methods by which we can populate a dataset?

0 Answers