[Mono-bugs] [Bug 53069][Cri] Changed - Stored proc returning more than one result set hangs
bugzilla-daemon@bugzilla.ximian.com
bugzilla-daemon@bugzilla.ximian.com
Thu, 3 Jun 2004 03:47:08 -0400 (EDT)
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 sumadevi@novell.com.
http://bugzilla.ximian.com/show_bug.cgi?id=53069
--- shadow/53069 2004-05-13 15:28:50.000000000 -0400
+++ shadow/53069.tmp.6814 2004-06-03 03:47:08.000000000 -0400
@@ -1,13 +1,13 @@
Bug#: 53069
Product: Mono: Class Libraries
Version: unspecified
OS: Debian Potato
OS Details:
-Status: NEW
-Resolution:
+Status: RESOLVED
+Resolution: FIXED
Severity: Unknown
Priority: Critical
Component: Sys.Data.SqlClient
AssignedTo: sumadevi@novell.com
ReportedBy: dheizer_avisi@hotmail.com
QAContact: mono-bugs@ximian.com
@@ -43,6 +43,44 @@
Everytime
Additional Information:
None
+
+------- Additional Comments From sumadevi@novell.com 2004-06-03 03:47 -------
+Hello,
+ I tried with the following sample program and dont see the problem.
+I have written the sample program based on your description of the
+problem.
+
+ string com = "EXECUTE sptest";
+ cmd = new SqlCommand(com,con);
+ try
+ {
+ reader = cmd.ExecuteReader();
+
+ while (reader.Read())
+ {
+ Console.WriteLine(reader.GetString(0));
+ }
+ if (reader.NextResult())
+ {
+
+
+ while (reader.Read())
+ {
+ Console.WriteLine(reader.GetString(0));
+ }
+
+sptest STORED PROCEDURE is defined as follows
+
+ ALTER PROCEDURE sptest
+AS
+ Select name from table1;
+ SELECT city from table2;
+RETURN
+
+
+I assume that the problem is fixed.
+Incase otherwise please let me know.
+