[Mono-bugs] [Bug 62042][Blo] New - 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 martineau_alain@hotmail.com.

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

--- shadow/62042	2004-07-28 10:17:18.000000000 -0400
+++ shadow/62042.tmp.9532	2004-07-28 10:17:18.000000000 -0400
@@ -0,0 +1,62 @@
+Bug#: 62042
+Product: Mono: Class Libraries
+Version: unspecified
+OS: 
+OS Details: Fedora core 2
+Status: NEW   
+Resolution: 
+Severity: Unknown
+Priority: Blocker
+Component: Sys.Data.SqlClient
+AssignedTo: rodrigo@novell.com                            
+ReportedBy: martineau_alain@hotmail.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Data not fill in DataSet
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+
+Steps to reproduce the problem:
+1. create a SqlClient.SqlDataAdapter
+2. Fill a DataSet
+3. Get Rows in DataSet
+
+Actual Results:
+Data isn't return, the same application is doing well in Visual Studio.Net.
+Only Column list is return (schema)
+
+
+Expected Results:
+DataTable in DS filled with Data
+
+
+How often does this happen?  always
+
+
+Additional Information:  Code
+	SqlConnection cnn = new SqlConnection();
+
+	cnn.ConnectionString = "user id=acgi;data source=\"192.168.0.66\";persist
+security info=True;initial catal" +
+		"og=Gem;password=igca";
+
+	System.Data.DataSet ds = new System.Data.DataSet();
+	cnn.Open();
+
+	SqlDataAdapter myDataAdapter = new SqlDataAdapter("select
+USR_lId,USR_vcName,USR_dtLastUpdated from usr_User",cnn);
+
+	myDataAdapter.Fill(ds);
+
+	cnn.Close();
+        cnn = null;
+
+		foreach (DataRow row in ds.Tables[0].Rows)
+		{
+       		Console.Write(row.ItemArray[0].ToString());
+       	        }