// conn is an OdbcConnection instance
OdbcCommand cmd = conn.CreateCommand(); 
OdbcTransaction trans = conn.BeginTransaction();  // start a transaction
cmd.Transaction = trans;
cmd.CommandText = "UPDATE staff " + " SET salary = (SELECT MIN(salary) " + 
           " FROM staff " + " WHERE id >= 310) " + " WHERE id = 310"; 
cmd.ExecuteNonQuery();  // execute the statement
trans.Commit();    // commit the transaction

// conn is an OdbcConnection instance
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "CALL IN_PARAM(?)"; 
 
// Register input parameter for the OdbcCommand 
cmd.Parameters.Add(new OdbcParameter("@p1", OdbcType.Int));
cmd.Parameters[0].Value = 100;
 
// Call the stored procedure 
cmd.ExecuteNonQuery();

// conn is an OdbcConnection instance
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT sid, name FROM staff WHERE sid > 100"; 
OdbcDataReader reader = cmd.ExecuteReader();
 
Int32 sid = 0;
String name = ""; 
 
// Output the results of the query
while(reader.Read()) { 
    sid = reader.GetInt32(0);   // first column
    name = reader.GetString(1);   // second column
    Console.WriteLine(" " + sid + " " + name); 
} 
 
reader.Close();

// Note: This C# example uses .NET Framework v1.1
// It connects to a Cloudscape/Derby database named SAMPLEDB.
// It creates a table called staff, inserts 3 rows, then fetches 
// and displays the result set on the console.
 
using System;
using System.Data;
using System.Data.Odbc;
 
namespace IBM.Cloudscape.Samples
{
     class Sample1
     {
          [STAThread]
          static void Main(string[] args)
          {
          //String connString = @"Driver={IBM DB2 ODBC
          //DRIVER};DBALIAS=SAMPLEDB;UID=abc;PWD=abc";  
             String connString = @"DSN=SAMPLEDB;UID=abc;PWD=abc";  // using DSN
             OdbcConnection conn = null;
             OdbcCommand cmd = null;
                     
             Console.WriteLine("Connecting to SAMPLEDB");
 
              try 
              {
                  conn = new OdbcConnection(connString);
 
                  // open database connection
                     conn.Open();
 
                     Console.WriteLine("Connected to SAMPLEDB");
                     
                  // creates a table named staff
                     cmd = new OdbcCommand("CREATE TABLE staff 
                          (sid INT PRIMARY KEY NOT NULL, name VARCHAR(30) 
                           NOT NULL, salary INT NOT NULL)", conn); 
 
                     cmd.ExecuteNonQuery();
 
                     Console.WriteLine("Table staff created");
 
                   // insert data to table staff
                     cmd.CommandText = "INSERT INTO staff VALUES (300, 'John', 35000)";
                     cmd.ExecuteNonQuery();
                            
                     cmd.CommandText = "INSERT INTO staff VALUES (310, 'Mary', 55000)";
                     cmd.ExecuteNonQuery();
                            
                     cmd.CommandText = "INSERT INTO staff VALUES (320, 'Tom', 35000)";
                     cmd.ExecuteNonQuery();
                            
                     Console.WriteLine("3 rows inserted");
 
                   // Fetch data from table staff
                     cmd = new OdbcCommand("SELECT * FROM staff", conn);
                     OdbcDataReader rdr = cmd.ExecuteReader();
 
                     Console.WriteLine("Fetching rows from staff");
 
                     while (rdr.Read())
                     {
                         Console.Write(rdr.GetInt32(0));
                         Console.Write(" " + rdr.GetString(1) + " ");
                         Console.WriteLine(rdr.GetInt32(2));
                     }
 
                         rdr.Close();
 
                     }
                     catch (OdbcException ex) 
                     {
                         int cnt = ex.Errors.Count;
                         for (int i=0; i < cnt; i++) 
                     {
                         Console.WriteLine("Error #" + i + "
" +
                         "Message: " + ex.Errors[i].Message + "
" +
                         "Native: " + ex.Errors[i].NativeError.ToString() + "
" +
                         "SQL: " + ex.Errors[i].SQLState + "
");
                     }
                 }
                     finally 
                     {
                         if (conn != null)
                           conn.Close();
 
                         Console.WriteLine("Sample1 ended");
                     }
              }
       }
}