[Mono-bugs] [Bug 62042][Blo] Changed - Data not fill in 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 sumadevi@novell.com.

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

--- shadow/62042	2004-07-28 23:31:29.000000000 -0400
+++ shadow/62042.tmp.27538	2004-07-29 06:11:17.000000000 -0400
@@ -1,13 +1,13 @@
 Bug#: 62042
 Product: Mono: Class Libraries
 Version: unspecified
 OS: unknown
 OS Details: Fedora core 2
-Status: NEW   
-Resolution: 
+Status: RESOLVED   
+Resolution: FIXED
 Severity: Unknown
 Priority: Blocker
 Component: Sys.Data.SqlClient
 AssignedTo: sumadevi@novell.com                            
 ReportedBy: martineau_alain@hotmail.com               
 QAContact: mono-bugs@ximian.com
@@ -72,6 +72,55 @@
 
 Thanks
 
 ------- Additional Comments From martineau_alain@hotmail.com  2004-07-28 22:28 -------
 The problem occured if a DateTime column value is null, in that case 
 the row is not return.
+
+------- Additional Comments From sumadevi@novell.com  2004-07-29 06:11 -------
+Hi
+  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
+
+