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..

Give me some tips in c#?

2312

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

2946

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

17146

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

2337