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 do u connect ado.net to sql server

1 Answers   Microsystems,

What is the difference in an abstract class and an interface?

0 Answers  

How would u connect to database using .NET?

5 Answers   TCS, Tesco,

How can we add/remove row's in "datatable" object of "dataset"?

0 Answers  

types of Store procedure in Sqlserver2000?

4 Answers  

What are the different ado.net namespaces?

0 Answers  

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

Explain what are acid properties?

0 Answers  

describe about the ado.net object model

4 Answers   TCS,

what is connection pooling ?

3 Answers   Vertex,

What are the three Ado objects?

6 Answers   Microsoft, StarSoft,

Where do you store connection string ?

3 Answers   Digital GlobalSoft,