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
How we work on N tire architecture in asp.net Please give me Examle...
how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?
Give me some tips in c#?
How to update and insert from datagridview at run time in excel database?