Access Oledb 接続

未分類
    private void InitDB()
    {
        // データベースをオープン
        connection.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = \\\\192.168.0.1\\access\\Address.accdb";
        connection.Open();

        string sql = "INSERT INTO テーブル1 VALUES(1, 'こねこ');";

        command.CommandText = sql;
        command.Connection = connection;


        command.ExecuteNonQuery();

        connection.Close();
    }