using System;
using System.IO;
using System.Data;
using System.Windows.Forms;
using Hitachi.HiRDB;                // .NET Framework Data Provider for HiRDB
 
namespace SAMPLE
{
    public class SAMPLE
    {
        static void Main()
        {
 
            HiRDBConnection connection1 = new HiRDBConnection
            ("datasource=C:\\Windows\\HiRDB.ini;UID=USER1;PWD=USER1;");
            HiRDBCommand cm = new HiRDBCommand();
 
                try
                {
                    // Connect  ........................................1
                    connection1.Open();
                    cm.Connection = connection1;
 
                    // *********************************************
                    // Example of retrieval by SAMPLE1 (C1 INT, C2 INT, C3 VARCHAR(30))  ...2
                    // *********************************************
                    // Create a parameter object
                    HiRDBParameter    par = cm.CreateParameter();
                    // Set parameter attributes
                    // Input parameter
                    par.Direction = ParameterDirection.Input;
                    // INTEGER type
                    par.HiRDBType = HiRDBType.Integer;
                    int aValue;
                    aValue = 200;
                    // Set parameter value
                    par.Value = aValue;
 
                    // Set SQL statement
                    cm.CommandText = "SELECT C2,C3 FROM SAMPLE1 WHERE C1=?
                                      WITH EXCLUSIVE LOCK NO WAIT";
                    // Assign parameter object
                    cm.Parameters.Add(par);
                    // Acquire DataReader object
                    HiRDBDataReader dr = cm.ExecuteReader();
                    int cnt=1;
                    Console.WriteLine("**** Searching ****");
                    while(dr.Read())
                    {
                        Console.WriteLine("**** "+cnt+"Searching row ***");
                        // Display data in C2
                        Console.WriteLine("C2="+dr.GetInt32(0));
                        // Display data in C3
                        Console.WriteLine("C3="+dr.GetString(1));
                        cnt ++;
                    }
                    // Free DataReader
                    dr.Close();
                    // Disconnect  .......................................3
                    connection1.Close();
                    connection1.Dispose();
 
                }
                catch (HiRDBException ex)  ..............................4
                {
                    // Output error information
                    Console.WriteLine(ex);
                    // Acquire individual information by the following process
                    // Output SQLCODE
                    Console.WriteLine("SQLCODE="+ex.ErrorCode);
                    // Output SQLERRM (SQL message)
                    Console.WriteLine("SQLERRM=" + ex.Message);
                }
        }
    }
}