mcs/class/Mono.Data.MySql/Test/TestMySqlExecuteReader.cs

   1 //\r
   2 // Test/SqlDataRead.cs\r
   3 //\r
   4 // Test to do read a simple forward read only record set.\r
   5 // Using SqlCommand.ExecuteReader() to return a SqlDataReader\r
   6 // which can be used to Read a row\r
   7 // and Get a String or Int32.\r
   8 //\r
   9 // Author:\r
  10 //      Daniel Morgan <danmorg@sc.rr.com>\r
  11 //\r
  12 // (C) 2002 Daniel Morgan\r
  13 //\r
  14 \r
  15 namespace TestSystemDataSqlClient {\r
  16         using System;\r
  17         using System.Data;\r
  18         using Mono.Data.MySql;\r
  19 \r
  20         class TestSqlDataReader {\r
  21 \r
  22                 [STAThread]\r
  23                 static void Main(string[] args) {\r
  24                         Console.WriteLine("Started.");\r
  25 \r
  26                         String connectionString = null;\r
  27                         connectionString =
  28                                 "dbname=mysql";
  29                                                 \r
  30                         MySqlConnection con;\r
  31                         Console.WriteLine("Create MySQL Connection...");\r
  32                         con = new MySqlConnection(connectionString);\r
  33                         Console.WriteLine("Open the connection...");\r
  34                         con.Open();\r
  35 \r
  36                         string sql;\r
  37                         sql = "select * from db";\r
  38 \r
  39                         Console.WriteLine("Create command...");\r
  40                         MySqlCommand cmd;\r
  41                         cmd = con.CreateCommand();\r
  42 \r
  43                         cmd.CommandText = sql;\r
  44 \r
  45                         MySqlDataReader reader;\r
  46                         Console.WriteLine("ExecuteReader...");\r
  47                         reader = cmd.ExecuteReader();\r
  48 \r
  49                         int row = 0;\r
  50                         Console.WriteLine("Reading data...");\r
  51                         while(reader.Read()){\r
  52                                 row++;\r
  53                                 Console.WriteLine("Row: " + row);\r
  54                                 for(int col = 0; col < reader.FieldCount; col++) {\r
  55                                         Console.WriteLine("  Field: " + col);\r
  56                                         \r
  57                                         Console.WriteLine("      Name: " + \r
  58                                                 reader.GetName(col));\r
  59                                         Console.WriteLine("      Value: " + \r
  60                                                 reader.GetValue(col));\r
  61                                 }\r
  62                         }\r
  63                         Console.WriteLine("Clean up...");\r
  64 \r
  65                         reader.Close();\r
  66                         reader = null;\r
  67                         cmd.Dispose();\r
  68                         cmd = null;\r
  69                         con.Close();\r
  70                         con = null;\r
  71 \r
  72                         Console.WriteLine("Done.");\r
  73                 }\r
  74         }\r
  75 }\r