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

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

17879

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

3144

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

2497

Give me some tips in c#?

2488