How to connect c# visual studio 2008 to Oracle with ADO.NET?
thanks for the answer.



How to connect c# visual studio 2008 to Oracle with ADO.NET? thanks for the answer...

Answer / bollu praveen yadav

First design the form in c# as per requirement and now you
want to retrieve data from oracle to C# using ADO.net then
follow these steps:

for example you want to retrieve emp table from oracle
database using ado.net

using system.data;
using system.data.oledb;
sqlconnection cn=new sqlconnection("user id=scott;
password=tiger; provider=msora.1; database=master;
datasource=server):
sqldataadapter da=new sqldataadapter("select *from emp",cn);
dataset ds=new dataset();
da.fill(ds, "d");
datagridview1.datasource=ds;


This way u can get the emp data from oracle to c# using
ado.net coding..

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More ADO.NET Code Interview Questions

how to retrive file ,using file info on click event of a buton and disply it on a web form

1 Answers   Activa Softec,


how to connect bind a control to database by writing a stored procedure?

3 Answers   Satyam,


How to connect c# visual studio 2008 to Oracle with ADO.NET? thanks for the answer.

1 Answers  


In the Design view in Visual Studio 2005 of an ASP.NET web page, what is the easiest way to create an event handler for the default event of an ASP.NET server control?

1 Answers  


How we work on N tire architecture in asp.net Please give me Examle...

3 Answers   ABC, HCL, IBM,






how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?

0 Answers  


Give me some tips in c#?

0 Answers  


How to update and insert from datagridview at run time in excel database?

0 Answers  


Categories
  • ASP.NET Code Interview Questions ASP.NET Code (46)
  • VB.NET Code Interview Questions VB.NET Code (9)
  • C Sharp Code Interview Questions C Sharp Code (51)
  • ADO.NET Code Interview Questions ADO.NET Code (8)