[Mono-bugs] [Bug 57779][Maj] Changed - MySqlClient DataAdapter not returning all the rows

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Wed, 28 Apr 2004 16:46:01 -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 baenapablo@hotmail.com.

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

--- shadow/57779	2004-04-28 12:38:14.000000000 -0400
+++ shadow/57779.tmp.10408	2004-04-28 16:46:01.000000000 -0400
@@ -190,6 +190,49 @@
   <Table>
     <numero>12412312</numero>
     <nombre>fdsfsdfsdfs</nombre>
   </Table>
 </NewDataSet>
 
+
+------- Additional Comments From baenapablo@hotmail.com  2004-04-28 16:46 -------
+This happens too with Npgsql:
+
+
+using System;
+using System.Data;
+using Npgsql;
+public class Test
+{
+
+
+    public static void Main () {
+      
+string connectionString = "server=localhost;database=xxxxxx;user
+id=xxxxxxxx;password=xxxxxxx;";
+                NpgsqlConnection dbcon;
+                dbcon = new NpgsqlConnection(connectionString);
+                dbcon.Open();
+
+            string sql = "SELECT numero, nombre FROM clietest";
+
+                NpgsqlDataAdapter adapter = new NpgsqlDataAdapter(sql,
+dbcon);
+
+                DataSet dataset = new DataSet ();
+                adapter.Fill (dataset);
+        Console.WriteLine (dataset.Tables [0].Rows.Count);
+                Console.WriteLine (dataset.GetXml ());
+
+    }
+
+}
+
+the database also has 3 registers and output is:
+
+1
+<NewDataSet>
+  <Table>
+    <numero>2123123</numero>
+    <nombre>avbsladlsdla</nombre>
+  </Table>
+</NewDataSet>