private void button1_Click(object sender, EventArgs e)
{
   string oradb = "Data Source=(DESCRIPTION="
      + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=LLMEDIA)(PORT=1521)))"
      + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
      + "User Id=scott;Password=tiger;";

   OracleConnection conn = new OracleConnection(oradb);
   conn.Open();
   string sql = "select dname from dept where deptno = 10";
   OracleCommand cmd = new OracleCommand(sql, conn);
   cmd.CommandType = CommandType.Text;

   OracleDataReader dr = cmd.ExecuteReader();
   dr.Read();
   label1.Text = dr.GetString(0); 
}



private void button1_Click(object sender, EventArgs e)
{
   string oradb = "Data Source=(DESCRIPTION="
      + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=LLMEDIA)(PORT=1521)))"
      + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
      + "User Id=scott;Password=tiger;";

   OracleConnection conn = new OracleConnection(oradb);
   conn.Open();
   string sql = "select * from emp";
   OracleCommand cmd = new OracleCommand(sql, conn);
   cmd.CommandType = CommandType.Text;

   OracleDataReader dr = cmd.ExecuteReader();
   dr.Read();
   dataGridView1.DataSource = dr;  
}



using System;
using System.Data;
using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;

namespace ProjectSP
{
	/// <summary>
	/// Summary description for Class1.
	/// </summary>
	public class Class1
	{
		public static void StoredProcedure1()
		{
			//
			// TODO: Add code here
			//
		}
	}
}





public static string GetCountryName(string CountryID)
{
	// retazec pre vysledok
	string CountryName = "";

	// definovanie pripojenia k databaze
	OracleConnection con = new OracleConnection();
	con.ConnectionString = "context connection=true";
	con.Open();

	// Parametricky prikaz pre vyber udajov
	OracleCommand cmd = con.CreateCommand();
	cmd.CommandText = "select country_name from countries where country_id = :1";
	cmd.Parameters.Add(":1", OracleDbType.Varchar2, CountryID, ParameterDirection.Input);
      
	OracleDataReader rdr = cmd.ExecuteReader();
	if(rdr.Read())
	{
		CountryName = rdr.GetString(0);
	}
	rdr.Close();
	cmd.Dispose();
	return CountryName;
}
