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

   1 //
   2 // TestParameters.cs - test parameters for the MySQL .NET Data Provider in Mono
   3 //                        using *Parameter and *ParameterCollection
   4 //
   5 // Note: it currently only tests input parameters.  Output is next on the list.
   6 //       Then output/input and return parameters.
   7 //
   8 // Author:
   9 //     Daniel Morgan <danmorg@sc.rr.com>
  10 //
  11 // (c)copyright 2002 Daniel Morgan
  12 //
  13
  14 using System;
  15 using System.Collections;
  16 using System.Data;
  17 using Mono.Data.MySql;
  18
  19 namespace TestMonoDataMySql {
  20
  21         public class TestParameters {
  22                 public static void Main() {
  23                         Console.WriteLine("** Start Test...");
  24
  25                         String connectionString = null;
  26                         connectionString =
  27                                 "dbname=test";
  28
  29                         MySqlConnection con;
  30                         Console.WriteLine("** Creating connection...");
  31                         con = new MySqlConnection(connectionString);
  32                         Console.WriteLine("** opening connection...");
  33                         con.Open();
  34
  35                         string charValue = "CD";
  36
  37                         string sql;
  38                         sql = "SELECT char_value, int_value FROM mono_mysql_test WHERE char_value = :inCharValue";
  39
  40                         Console.WriteLine("** Creating command...");
  41                         MySqlCommand cmd = new MySqlCommand(sql, con);
  42
  43                         // add parameter for inTableName
  44                         Console.WriteLine("** Create parameter...");
  45                         MySqlParameter parm = new MySqlParameter("inCharValue", DbType.String);
  46
  47                         Console.WriteLine("** set direction of parameter to input");
  48                         parm.Direction = ParameterDirection.Input;
  49
  50                         Console.WriteLine("** set the parameter value...");
  51                         parm.Value = charValue;
  52
  53                         Console.WriteLine("** add parameter to parameters collection in the command...");
  54                         cmd.Parameters.Add(parm);
  55
  56                         MySqlDataReader rdr;
  57                         Console.WriteLine("** ExecuteReader()...");
  58
  59                         rdr = cmd.ExecuteReader();
  60
  61                         Console.WriteLine("[][] And now we are going to our results [][]...");
  62                         int c;
  63                         int results = 0;
  64                         do {
  65                                 results++;
  66                                 Console.WriteLine("Result Set " + results + "...");
  67
  68                                 // get the DataTable that holds
  69                                 // the schema
  70                                 DataTable dt = rdr.GetSchemaTable();
  71
  72                                 // number of columns in the table
  73                                 Console.WriteLine("   Total Columns: " +
  74                                         dt.Columns.Count);
  75
  76                                 // display the schema
  77                                 foreach (DataRow schemaRow in dt.Rows) {
  78                                         foreach (DataColumn schemaCol in dt.Columns)
  79                                                 Console.WriteLine(schemaCol.ColumnName +
  80                                                         " = " +
  81                                                         schemaRow[schemaCol]);
  82                                         Console.WriteLine();
  83                                 }
  84
  85                                 string output, metadataValue, dataValue;
  86                                 int nRows = 0;
  87
  88                                 // Read and display the rows
  89                                 while(rdr.Read()) {
  90                                         Console.WriteLine("   Row " + nRows + ": ");
  91
  92                                         for(c = 0; c < rdr.FieldCount; c++) {
  93                                                 // column meta data
  94                                                 DataRow dr = dt.Rows[c];
  95                                                 metadataValue =
  96                                                         "    Col " +
  97                                                         c + ": " +
  98                                                         dr["ColumnName"];
  99
 100                                                 // column data
 101                                                 if(rdr.IsDBNull(c) == true)
 102                                                         dataValue = " is NULL";
 103                                                 else
 104                                                         dataValue =
 105                                                                 ": " +
 106                                                                 rdr.GetValue(c);
 107
 108                                                 // display column meta data and data
 109                                                 output = metadataValue + dataValue;
 110                                                 Console.WriteLine(output);
 111                                         }
 112                                         nRows++;
 113                                 }
 114                                 Console.WriteLine("   Total Rows: " +
 115                                         nRows);
 116                         } while(rdr.NextResult());
 117                         Console.WriteLine("Total Result sets: " + results);
 118
 119                         con.Close();
 120                 }
 121         }
 122 }