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

   1 //
   2 // TestSqlDataAdapter - tests SqlDataAdapter, DbDataAdapter, DataSet, DataTable,
   3 //                      DataRow, and DataRowCollection by retrieving data
   4 //
   5 // Authors:
   6 //      Tim Coleman <tim@timcoleman.com>
   7 //      Daniel Morgan <danmorg@sc.rr.com>
   8 //
   9 // (c)copyright 2002 Tim Coleman
  10 // (c)copyright 2002 Daniel Morgan
  11 //
  12
  13 using System;
  14 using System.Collections;
  15 using System.Data;
  16 using System.Data.SqlClient;
  17
  18 namespace TestSystemDataSqlClient
  19 {
  20         public class TestSqlDataAdapter
  21         {
  22                 public static void Test()
  23                 {
  24                         string connectionString;
  25                         string sqlQuery;
  26                         SqlDataAdapter adapter;
  27                         DataSet dataSet = null;
  28
  29                         connectionString =
  30                                 "host=localhost;" +
  31                                 "dbname=test;" +
  32                                 "user=postgres";
  33
  34                         sqlQuery = "select * from pg_tables";
  35
  36                         System.Console.WriteLine ("new SqlDataAdapter...");
  37                         adapter = new SqlDataAdapter (sqlQuery,
  38                                         connectionString);
  39
  40                         System.Console.WriteLine ("new DataSet...");
  41                         dataSet = new DataSet ();
  42
  43                         try {
  44                                 System.Console.WriteLine("Fill...");
  45                                 adapter.Fill (dataSet);
  46
  47                         }
  48                         catch (NotImplementedException e) {
  49                                 Console.WriteLine("Exception Caught: " + e);
  50                         }
  51
  52                         System.Console.WriteLine ("get row...");
  53                         if (dataSet != null) {
  54                                 foreach (DataRow row in dataSet.Tables["Table"].Rows)
  55                                         Console.WriteLine("tablename: " + row["tablename"]);
  56                                 System.Console.WriteLine("Done.");
  57                         }
  58
  59                 }
  60
  61                 public static void Main()
  62                 {
  63                         Test();
  64                 }
  65         }
  66 }