[Mono-list] adapter.Fill(dataset)

Carlo "Jedi" carlo.jedi@virgilio.it
Wed, 21 Jan 2004 02:42:54 +0100


Hi all, I'm new in this mailing list and I have a great problem:

I'm using Mono 0.29 (but I've tried also earlier versions, cvs and daily 
builds), MySQL 4.0.17 (but I've tried also earlier versions) and ByteFX Data 
Provider (the one included in Mono and also ver 0.74 and earlier versions).

My problem is that when I do "adapter.Fill(dataset)" only first two records 
are stored even if table has 5,10,100,n records. 
I've tested the "select" and it is working fine, so problem seems to be 
located in fill method. 
This is my code:

###############################################
MySqlConnection myConnection = new MySqlConnection();
try
{
myConnection.ConnectionString = "Server=myserver;database=mydb;User 
ID=mylogin;password=mypass;";
myConnection.Open();
MySqlCommand myCommand = new MySqlCommand("SELECT idServizio FROM TServizi 
where IdPadre=0",myConnection);
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = myCommand;
DataSet myDs = new DataSet();
adapter.Fill(myDs);
Console.WriteLine("myDs.Tables[0].Rows.Count);
myConnection.Dispose();
}
catch (Exception e)
{
Console.WriteLine(e.ToString()); 
}

###############################################

Could you help me? I've also tried to connect to MsSQL instead of MySQL and it 
works fine, so problem really seems to be ByteFX... is there any other data 
provider for mono/mysql??? Thank you in advance.