Re: [Firebird-net-provider] A problem with C# sample code

[Carlos G.A. <car...@te...>]

Hello:

Test with this:

 using System;
 using System.Data;
 using FirebirdSql.Data.Firebird;
 
 public class Test 
 {
    public static void Main(string[] args)
    {
	string connectionString = 
	       "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
	       "User=SYSDBA;" +
	       "Password=masterkey;" +
	       "Dialect=3;" +
	       "Server=localhost";
	IDbConnection dbcon = new FbConnection(connectionString);
	dbcon.Open();
	IDbTransaction dbtxn = dbcon.BeginTransction();
       	IDbCommand dbcmd = dbcon.CreateCommand();
       	string sql = "SELECT * FROM employee";
	dbcmd.CommandText = sql;
	dbcmd.Transction = dbtxn; 
       	IDataReader reader = dbcmd.ExecuteReader();
       	while(reader.Read()) {
            object dataValue = myReader.GetValue(0);
            string sValue = dataValue.ToString();
            Console.WriteLine("Value: " + sValue);
       	}
       	// clean up
       	reader.Close();
       	reader = null;
       	dbcmd.Dispose();
       	dbcmd = null;
       	dbcon.Close();
       	dbcon = null;
    }
}





Best regards
Carlos Guzmán Álvarez
Vigo-Spain


P.S: Please send message to the list in plain text format, thanks.