using CommandBehavior = System.Data.CommandBehavior;
using Console         = System.Console;
using OdbcCommand     = System.Data.Odbc.OdbcCommand;
using OdbcConnection  = System.Data.Odbc.OdbcConnection;
using OdbcDataReader  = System.Data.Odbc.OdbcDataReader;
using OdbcException   = System.Data.Odbc.OdbcException;

namespace consum
{
	class Class1
	{
		static void Main(string[] args)
		{
			try
			{
				string tConnectionString = "DSN=Pdcl0bjc_prices;UID=nobody;PWD=;";
				OdbcConnection tConnection = new OdbcConnection(tConnectionString);
				string tSQLString = "SELECT goods, price FROM consum";
				OdbcCommand tOdbcCommand = new OdbcCommand(tSQLString, tConnection);
				tConnection.Open();
				OdbcDataReader tOdbcDataReader = 
					tOdbcCommand.ExecuteReader(CommandBehavior.SequentialAccess);
				while (tOdbcDataReader.Read())
				{
					Console.WriteLine(tOdbcDataReader.GetString(0) + " " +
							          tOdbcDataReader.GetDouble(1));
				}
				tConnection.Close();
			}
            catch (OdbcException pOdbcException)
            {
                Console.WriteLine(pOdbcException.StackTrace);
                for (int i=0; i < pOdbcException.Errors.Count; i++){
                    Console.WriteLine("Index #" + i);
                    Console.WriteLine("Message: " + 
                                      pOdbcException.Errors[i].Message);                    
                    Console.WriteLine("Native: " + 
                                      pOdbcException.Errors[i].NativeError.ToString());
                    Console.WriteLine("Source: " +
                                      pOdbcException.Errors[i].Source);
                    Console.WriteLine("SQL: " + 
                                      pOdbcException.Errors[i].SQLState);
                }
            }
			System.Threading.Thread.Sleep(15000);
        }
	}
}