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 |
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?
how to connect bind a control to database by writing a stored procedure?
Give me some tips in c#?
How to connect c# visual studio 2008 to Oracle with ADO.NET? thanks for the answer.
How we work on N tire architecture in asp.net Please give me Examle...
how to retrive file ,using file info on click event of a buton and disply it on a web form
how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?
How to update and insert from datagridview at run time in excel database?