[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>