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

What are typed and untyped dataset?

0 Answers  

What is difference between sqldatareader and sqldataadapter?

0 Answers  

What is the difference between executenonquery () and executescalar ()?

0 Answers  

How many major types of connection objects in ADO.NET?

0 Answers   MCN Solutions,

What are the two fundamental objects in ADO.NET?

8 Answers   Ksb, TCS,

explain connection less and with connection?diference between data reader,data set,data adapter? can we use data reader,data set in a single application? if yes explain with simple code,if no explain?

3 Answers   Techno Labs,

Which is the best institute in navi mumbai to learn DotNet

2 Answers  

Write steps of retrieving data using ado.net ?

3 Answers   Keane India Ltd,

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

Is it possible to edit data in Repeater control?

0 Answers  

what is the criteria of selection in sbi interview?

1 Answers   BCS, State Bank Of India SBI,

What is data relation?

0 Answers