c# Datenbankzugriffe

db2 Zugriff

im Projekt Verweis auf ibm.data.db2.dll

using IBM.Data.DB2;

private void test
{
  String MyDb2ConnectionString = "";
  MyDb2ConnectionString = "Server=server:50000;Database=D3P;UID=user;PWD=passwort;";
  DB2Command MyDB2Command = null;
  DB2Connection MyDb2Connection = new DB2Connection(MyDb2ConnectionString);
  MyDb2Connection.Open();
  MyDB2Command = MyDb2Connection.CreateCommand();
  MyDB2Command.CommandText = "SELECT * from  Schema.Tabelle where Feld1 = 'aaaa'";
  Console.WriteLine(MyDB2Command.CommandText);
  DB2DataReader MyDb2DataReader = null;
  MyDb2DataReader = MyDB2Command.ExecuteReader();
  while (MyDb2DataReader.Read())
  {
     try
     {
        MessageBox.Show(MyDb2DataReader["Feldname"].ToString());
     }
     catch (Exception e)
     {
         Console.Write(e.ToString());
      }
    }
    MyDb2DataReader.Close();
    MyDB2Command.Dispose();
    MyDb2Connection.Close();
}

Access Zugriff

OleDbConnection TTTConn;
OleDbCommand oleDbCmd = new OleDbCommand();
String connParam = @“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c‘:\daten\db.mdb‘;Persist Security Info=False“;
TTTConn = new OleDbConnection(connParam);
InitializeComponent();
TTTConn.Open();