[Mono-bugs] [Bug 66925][Nor] Changed - DbDataAdapter does not fill rows with null DateTime column values

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Tue, 28 Sep 2004 00:30:15 -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=66925

--- shadow/66925	2004-09-27 23:53:58.000000000 -0400
+++ shadow/66925.tmp.749	2004-09-28 00:30:15.000000000 -0400
@@ -1,13 +1,13 @@
 Bug#: 66925
 Product: Mono: Class Libraries
 Version: unspecified
 OS: All
 OS Details: mono version 1.0
-Status: NEW   
-Resolution: 
+Status: RESOLVED   
+Resolution: DUPLICATE
 Severity: Unknown
 Priority: Normal
 Component: Sys.Data
 AssignedTo: sumadevi@novell.com                            
 ReportedBy: rscaletta@augustmack.com               
 QAContact: mono-bugs@ximian.com
@@ -52,6 +52,70 @@
 Change 1102 to
     this.SetValue(index, record.GetValue(field));
 
 The SetValue method in DateTimeDataContainer already safely converts any
 object to a DateTime.  Additionally, the GetValue method will not throw an
 exception, it will just return DBNull.
+
+------- Additional Comments From sumadevi@novell.com  2004-09-28 00:30 -------
+Information copied from bug 60398
+
+
+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
+
+
+
+
+
+*** This bug has been marked as a duplicate of 60398 ***