Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to get the new oledb connection of oracle in database
programming?



How to get the new oledb connection of oracle in database programming?..

Answer / srikant dwibedi

using OLEDB connection we can connect the MS-ACCESS,Sql
Server,Oracle.

here i given the coding for connect the oledb connection

OleDbConnection con = new OleDbConnection();
con.ConnectionString="Provider=Microsoft.Jet.OleDb.4.0;Data
Source=databasenamewithpath;";
con.Open();

then u can use the dataset or datareader
OleDbCommand cmd = new OleDbCommand(sql,con);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();


OleDbDataReader reader;
reader = cmd.ExecuteReader();


OleDbDataAdapter oda = new OleDbDataAdapter(sql,con);
DataSet ds = new DataSet();
oda.Fill(ds,"tablename");

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?

5 Answers   HCL,


Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,


What is Data view?

0 Answers  


What is the difference in record set and dataset?

0 Answers  


What is shadow copy?

0 Answers  


What is the use of parameter object?

4 Answers   CDC, Ksb,


Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  


What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  


What is a non query?

0 Answers  


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

0 Answers  


What is difference between connected and disconnected architecture in ado.net?

0 Answers  


What is ado connection?

0 Answers  


Categories