Csharp/C Sharp/Database ADO.net/DB2

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

OleDbConnection Connect to DB2: DB2 connection string

<source lang="csharp"> using System; using System.Data; using System.Data.OleDb; class Db2Connect{

  static void Main() {
     string connString = @"provider = IBMDADB2.1;persist security info = false;data source = sample;";
     OleDbConnection conn = new OleDbConnection(connString);
     try
     {
        conn.Open();
        Console.WriteLine("Connection opened.");
        Console.WriteLine("Connection Properties:");   
        Console.WriteLine("\tConnection String: {0}", conn.ConnectionString);    
        Console.WriteLine("\tDatabase: {0}",conn.Database);   
        Console.WriteLine("\tDataSource: {0}",conn.DataSource);
        Console.WriteLine("\tServerVersion: {0}",conn.ServerVersion);
        Console.WriteLine("\tState: {0}",conn.State);
     } catch (OleDbException e) {
        Console.WriteLine("Error: " + e);  
     } finally {
        conn.Close();
        Console.WriteLine("Connection closed.");
     }
  }

}


      </source>


Use DB2Connection class to connect to a DB2 database

<source lang="csharp"> using System; using System.Data; using IBM.Data.DB2; class Db2Connect{

  static void Main() {
      string connString = @"database = sample;";
      DB2Connection conn = new DB2Connection(connString);
      try {
        conn.Open();
        Console.WriteLine("Connection opened.");
        // Display connection properties
        Console.WriteLine("Connection Properties:");   
        Console.WriteLine("\tConnection String: {0}", conn.ConnectionString);    
        Console.WriteLine("\tDatabase: {0}",conn.Database);   
        Console.WriteLine("\tServerVersion: {0}",conn.ServerVersion);
        Console.WriteLine("\tState: {0}",conn.State);
     } catch (DB2Exception e) {
        Console.WriteLine("Error: " + e);  
     } finally  {
        conn.Close();
        Console.WriteLine("Connection closed.");
     }
  }

}


      </source>