[Mono-bugs] [Bug 72607][Wis] Changed - mono don't close connection on Fill call (DATASET)

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by tsureshkumar@novell.com.

http://bugzilla.ximian.com/show_bug.cgi?id=72607

--- shadow/72607	2005-02-15 08:48:37.000000000 -0500
+++ shadow/72607.tmp.25624	2005-02-15 08:52:58.000000000 -0500
@@ -1,12 +1,12 @@
 Bug#: 72607
 Product: Mono: Class Libraries
 Version: 1.1
 OS: unknown
 OS Details: Gentoo
-Status: NEW   
+Status: NEEDINFO   
 Resolution: 
 Severity: Unknown
 Priority: Wishlist
 Component: Sys.Data
 AssignedTo: tsureshkumar@novell.com                            
 ReportedBy: informatique.internet@fiducial.fr               
@@ -20,6 +20,41 @@
 if the connection isn't open:
 1 it opens the connection
 2 it does the transaction
 3 it closes the connection
 
 We've seen that mono opens the connection but it doesn't close it...
+
+------- Additional Comments From tsureshkumar@novell.com  2005-02-15 08:52 -------
+I couldn't reproduce this. I executed the following code and works
+perfectly. Could you please post any sample program which fails.
+
+using System;
+using System.IO;
+using System.Data;
+using ByteFX.Data.MySqlClient;
+
+
+public class MainClass
+{
+        public static void Main (string [] args)
+                {
+                        
+                        string connString =
+"SERVER=localhost;database=test;USER ID=mono-tester;PASSWORD=mono-tester";
+                        
+                        MySqlConnection conn = new MySqlConnection
+(connString);
+                        using (conn) 
+                                {
+                                        MySqlDataAdapter da = new
+MySqlDataAdapter ("select * from test", conn);
+                                        DataSet ds = new DataSet
+("table");
+                                        da.Fill (ds);
+                                        Console.WriteLine ("state
+{0}", conn.State.ToString ());
+                                        conn.Close ();
+                                }
+                }
+}
+