mcs/class/System.Data/Test/OdbcTest.cs

   1 //\r
   2 // OdbcTest.cs - Test for the ODBC ADO.NET Provider in System.Data.Odbc \r
   3 //\r
   4 // The test works on Windows XP using Microsoft .NET Framework 1.1 Beta\r
   5 //\r
   6 // To compile under Windows using Microsoft .NET 1.1\r
   7 // E:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\csc OdbcTest.cs /reference:System.Data.dll\r
   8 //\r
   9 // To compile under Windows using Mono:\r
  10 // mcs OdbcTest.cs -r System.Data.dll\r
  11 //\r
  12 // I have not tested it on Linux using unixODBC\r
  13 //\r
  14 // Author:\r
  15 //     Daniel Morgan <danmorg@sc.rr.com>\r
  16 //\r
  17 \r
  18 using System;\r
  19 using System.Data;\r
  20 using System.Data.Odbc;\r
  21 \r
  22 namespace Test.OdbcTest\r
  23 {\r
  24         class OdbcTest\r
  25         {\r
  26                 [STAThread]\r
  27                 static void Main(string[] args)\r
  28                 {\r
  29                         OdbcConnection dbcon = new OdbcConnection();\r
  30                         // connection string to a Microsoft SQL Server 2000 database\r
  31                         // that does not use a DSN\r
  32                         //dbcon.ConnectionString = \r
  33                         //      "DRIVER={SQL Server};" + \r
  34                         //      "SERVER=(local);" + \r
  35                         //      "Trusted_connection=true;" +\r
  36                         //      "DATABASE=pubs;";\r
  37 \r
  38                         // connection string that uses a DSN.\r
  39                         dbcon.ConnectionString = \r
  40                                 "DSN=LocalServer;UID=sa;PWD=";\r
  41                                 \r
  42                         dbcon.Open();\r
  43 \r
  44                         OdbcCommand dbcmd = new OdbcCommand();\r
  45                         dbcmd.Connection = dbcon;\r
  46                         dbcmd.CommandType = CommandType.Text;\r
  47                         dbcmd.CommandText = "SELECT lname FROM employee";\r
  48                         \r
  49                         OdbcDataReader reader;\r
  50                         reader = (OdbcDataReader) dbcmd.ExecuteReader();\r
  51 \r
  52                         while(reader.Read()) {\r
  53                                 Console.WriteLine("Last Name: " + reader[0].ToString());\r
  54                         }\r
  55                         reader.Close();\r
  56                         dbcmd.Dispose();\r
  57                         dbcon.Close();\r
  58                 }\r
  59         }\r
  60 }\r