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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2195


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

16579


Give me some tips in c#?

2160


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

2759