Reading an iSeries table in C# (with video)

Here's another simple example of reading a table in C# from the iSeries.
  See the video for this here. 

   Download the Visual Studio Project here

As you can see (line 13)  all you need in the connection string is the IP address of your machine. If you don't include the log on parameters -UserID=myuser; Password=mypass, then you will be prompted for them by the iSeries.
You need to include the IBM .net provider in your 'References' in your Visual Studio project. It's located in the Client Access directory. If you don't have client access, then download the 'technology preview' from IBM for free.

   1:  using System;

   2:  using System.Collections.Generic;

   3:  using System.Text;

   4:  using IBM.Data.DB2.iSeries;

   5:   

   6:  namespace Prez_Rank

   7:  {

   8:      class Program

   9:      {

  10:          static void Main(string[] args)

  11:          {

  12:              iDB2Connection conn = new iDB2Connection();

  13:              conn.ConnectionString = "DataSource=192.168.0.1";

  14:              conn.Open();

  15:   

  16:              iDB2Command cmd = new iDB2Command();

  17:              cmd.CommandText = "Select * from colm.customers";

  18:              cmd.Connection = conn;

  19:   

  20:   

  21:   

  22:              iDB2DataReader dr= cmd.ExecuteReader();

  23:   

  24:              while (dr.Read())

  25:              {

  26:                  Console.WriteLine(dr.GetString(0));

  27:   

  28:              }

  29:              Console.ReadLine();

  30:   

  31:          }

  32:      }

  33:  }