[Mono-bugs] [Bug 60398][Cri] Changed - SqlDataAdapter.Fill

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Fri, 13 Aug 2004 00:22:19 -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=60398

--- shadow/60398	2004-08-12 14:17:59.000000000 -0400
+++ shadow/60398.tmp.25003	2004-08-13 00:22:19.000000000 -0400
@@ -1,13 +1,13 @@
 Bug#: 60398
 Product: Mono: Class Libraries
 Version: unspecified
 OS: All
 OS Details: Liniux RedHat9 and Windows
-Status: REOPENED   
-Resolution: 
+Status: RESOLVED   
+Resolution: FIXED
 Severity: Unknown
 Priority: Critical
 Component: Sys.Data.SqlClient
 AssignedTo: sumadevi@novell.com                            
 ReportedBy: haag.wolfgang@oce.de               
 QAContact: mono-bugs@ximian.com
@@ -104,6 +104,65 @@
 The bug appears only if there are DB.Null Values in the Databasetable.
 With Mono Version beta1 the failere donīt appear.
 
 ------- Additional Comments From mbazzano@unt.edu.ar  2004-08-12 14:17 -------
 This still happens in Mono 1.0.1 with NULL or DBNull values in 
 DATETIME type columns (MS SQL Server).
+
+------- Additional Comments From sumadevi@novell.com  2004-08-13 00:22 -------
+i
+  This bug was reported and was fixed on 7/7/2004. Can you please
+check with a version from CVS after 7/7/2004.
+
+Here is the sample code that I have which works along with the table dump
+
+String connectionString = null;
+			SqlConnection con;
+			SqlCommand cmd;
+			SqlDataReader reader;
+			try
+			{
+				//Fill the conenction string for SQL Server
+				connectionString =
+					"Server=164.99.168.131;" +
+					"Database=Northwind;" +
+					"User ID=sa;" +
+					"Password=novell";
+				con = new SqlConnection(connectionString);
+				Console.WriteLine ("Opening Connection...");
+				SqlDataAdapter myadapter = new SqlDataAdapter("select * from
+table2;",con);
+
+				con.Open ();
+				DataTable dt = new DataTable();
+				myadapter.Fill(dt);
+				Console.WriteLine("here count {0}",dt.Rows.Count);
+				con.Close();
+			}
+			catch (Exception e)
+			{
+				Console.WriteLine("exception {0}",e);
+
+			}
+
+Table Dump
+
+col_char,col_date
+one,4/12/2003 4:59:00
+two,<null>
+three,<null>
+
+
+OUTPUT OF THE PROGRAM
+here count 3
+
+
+This bug is the same as 62042. Please reverify whether the problem occurs.
+Also updating the above testcase in the Test folder.
+
+
+
+Regards
+Uma
+
+
+