C# - oracle database a Neošetřená výjimka – .NET – Fórum – Programujte.com

Zdavim,
chtěl jsem si z nudy udělat databazi v oracle, stahnul, zalozil sloupce i tabulku, ale kdyz pak začnu psát do c# a vyleze mi z toho temhle kód:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.OleDb;

using System.Data;

using System.Data.SqlClient;

using System.Windows.Forms;

using Oracle.DataAccess.Client;

using System.Globalization;



namespace Databaze

{

    class Program

    {

        static void Main(string[] args)

        {

            string oradb = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));User Id=sys;Password=******;";

            OracleConnection conn = new OracleConnection(oradb);

            conn.Open();

            OracleCommand cmd = new OracleCommand();

            cmd.Connection = conn;

            cmd.CommandText = "select*from jmena";

            cmd.CommandType = CommandType.Text;





             OracleDataReader reader = cmd.ExecuteReader();



            Console.WriteLine(reader.Read());  

           

            

            

        }

    }

}

No a na ktorom riadku ti to zdochne? S Oracle sice nemam skusenosti a nepoznam ten driver, ale MSSQL ci Sybase by toto zozral:

[CODE]
string connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));User Id=sys;Password=******;";

using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
using (OracleCommand command = new OracleCommand(
"SELECT Priezvisko FROM Jmena", connection))
{
OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (!reader.Read())
throw new Exception("Data neexistuju!");

string priezvisko = reader.GetString(0);
Console.WriteLine(priezvisko);
} // using
} // using
[/CODE]

Nefunguje ale diky.