database connectivity (olracle)

Question

code for connecting to oracle database with in ado.net(visual studio10 oracle 10g XE)

Anubhav Chaudhary · Answer

Connecting Oracle is just similar to SQL you just need to take System.Data.Oledb instead of System.Data.SQLClient. After that you can use this code for connectivity:- OleDbConnection x; OleDbCommand y; OleDbDataReader z; private void Form1_Load(object sender EventArgs e) { x = new OleDbConnection(provider=msdaora;user id=scott; password=tiger); x.Open(); y = new OleDbCommand(select * from emp x); z = y.ExecuteReader(); while (z.Read()) { MessageBox.Show(z[empno] +   + z[ename].ToString() +   + z[2].ToString()); } x.Close(); } You can use this code to display the data of emp Table. Here I had use the User Id and Password which are used on my System you need to change them according to your System. I hope this will work for you. Accept the Ans if it helps you.

Pankaj Pandey · Answer

check it.. http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm http://msdn.microsoft.com/en-us/library/92ceczx1(v=vs.80).aspx