в 15:31, 26 мая 2010

2010-05-26T15:31:19Z

Admin: 1 версия

2010-05-26T11:42:30Z

1 версия

Новая страница

==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>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Csharp/C Sharp/Database ADO.net/DB2 - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия