TestOleDb.cs 699 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. using System;
  2. using System.Data.OleDb;
  3. namespace System.Data.OleDb.Test
  4. {
  5. public class TestOleDb
  6. {
  7. private OleDbConnection m_cnc;
  8. private TestOleDb ()
  9. {
  10. m_cnc = new OleDbConnection ("PostgreSQL");
  11. m_cnc.Open ();
  12. }
  13. void TestDataReader ()
  14. {
  15. string sql = "SELECT * FROM pg_tables";
  16. OleDbCommand cmd = new OleDbCommand (sql, m_cnc);
  17. IDataReader reader = cmd.ExecuteReader ();
  18. }
  19. void Close ()
  20. {
  21. m_cnc.Close ();
  22. }
  23. static void Main (string[] args)
  24. {
  25. try {
  26. TestOleDb test = new TestOleDb ();
  27. test.TestDataReader ();
  28. test.Close ();
  29. } catch (Exception e) {
  30. Console.WriteLine ("An error has occured: {0}", e.ToString ());
  31. }
  32. }
  33. }
  34. }