2005-04-12 Dick Porter <dick@ximian.com>

[mono.git] / mcs / class / System.Data / Test / TestSqlDataAdapter.cs

diff --git a/mcs/class/System.Data/Test/TestSqlDataAdapter.cs b/mcs/class/System.Data/Test/TestSqlDataAdapter.cs
index e941c7343facba821da8680e0ce81d046f2d0376..841f9b7477ae8f0e64689abb508ccab047236df0 100644 (file)
--- a/mcs/class/System.Data/Test/TestSqlDataAdapter.cs
+++ b/mcs/class/System.Data/Test/TestSqlDataAdapter.cs
@@ -1,9 +1,7 @@
 //
-// TestSqlDataAdapter - tests SqlDataAdapter, DbDataAdapter, DataSet, DataTable,
+// TestPgSqlDataAdapter - tests PgSqlDataAdapter, DbDataAdapter, DataSet, DataTable,
 //                      DataRow, and DataRowCollection by retrieving data
 //
-// Note: it currently causes an NotImplementException for SqlCommand::NextResult()
-//
 // Authors:
 //      Tim Coleman <tim@timcoleman.com>
 //      Daniel Morgan <danmorg@sc.rr.com>
@@ -12,22 +10,44 @@
 // (c)copyright 2002 Daniel Morgan
 //
 
+//
+// Copyright (C) 2004 Novell, Inc (http://www.novell.com)
+//
+// Permission is hereby granted, free of charge, to any person obtaining
+// a copy of this software and associated documentation files (the
+// "Software"), to deal in the Software without restriction, including
+// without limitation the rights to use, copy, modify, merge, publish,
+// distribute, sublicense, and/or sell copies of the Software, and to
+// permit persons to whom the Software is furnished to do so, subject to
+// the following conditions:
+// 
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+// 
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+//
+
 using System;
 using System.Collections;
 using System.Data;
-using System.Data.SqlClient;
+using Mono.Data.PostgreSqlClient;
 
-namespace TestSystemDataSqlClient 
+namespace TestSystemDataPgSqlClient 
 {
-       public class TestSqlDataAdapter 
+       public class TestPgSqlDataAdapter 
        {
                public static void Test() 
                {
                        string connectionString;
                        string sqlQuery;
-                       SqlDataAdapter adapter;
-                       DataSet dataSet;
-                       DataRow row;
+                       PgSqlDataAdapter adapter;
+                       DataSet dataSet = null;
 
                        connectionString =
                                "host=localhost;" +
@@ -36,17 +56,14 @@ namespace TestSystemDataSqlClient
                                                
                        sqlQuery = "select * from pg_tables";
 
-                       try {
-                               System.Console.WriteLine ("new SqlDataAdapter...");
-                               adapter = new SqlDataAdapter (sqlQuery, 
-                                               connectionString);
+                       System.Console.WriteLine ("new PgSqlDataAdapter...");
+                       adapter = new PgSqlDataAdapter (sqlQuery, 
+                                       connectionString);
 
-                               System.Console.WriteLine ("open connection...");
-                               adapter.SelectCommand.Connection.Open ();
-                               
-                               System.Console.WriteLine ("new DataSet...");
-                               dataSet = new DataSet ();
+                       System.Console.WriteLine ("new DataSet...");
+                       dataSet = new DataSet ();
 
+                       try {
                                System.Console.WriteLine("Fill...");
                                adapter.Fill (dataSet);
 
@@ -56,10 +73,11 @@ namespace TestSystemDataSqlClient
                        }               
                        
                        System.Console.WriteLine ("get row...");
-                       row = dataSet.Tables["Table"].Rows[0];
-
-                       Console.WriteLine("tablename: " + row["tablename"]);
-                       System.Console.WriteLine("Done.");
+                       if (dataSet != null) {
+                               foreach (DataRow row in dataSet.Tables["Table"].Rows)
+                                       Console.WriteLine("tablename: " + row["tablename"]);
+                               System.Console.WriteLine("Done.");
+                       }
 
                }