[Mono-list] ByteFX MySql on Mono problem

Dan Cimpoiesu dan.cimpoiesu@mymail.ro
Thu, 2 Sep 2004 15:37:59 +0200


This is a multi-part message in MIME format.

------=_NextPart_000_008C_01C49102.D37CA560
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I use the following piece of code.

///
Remoting.BackupDataSet data;

data=3Dnew Remoting.BackupDataSet();

String connectionString=3D"Database=3Ddionbackupserver;Data =
Source=3D192.168.90.2;User Id=3Droot;Password=3D";

String commandText=3D"SELECT =
UserID,Name,Serial,DateIssued,DateStart,DateEnd,Trial,DiskSpace FROM =
users";

MySqlDataAdapter adapter=3Dnew =
MySqlDataAdapter(commandText,connectionString);

adapter.Fill(data.Users);

MessageBox.Show(data.Users.Rows.Count.ToString());

///

I use the ByteFX components for connecting to MySQL

Remoting.BackupDataSet is a strong typed DataSet that contains the table =
Users

On windows these piece of code works ok.

On linux with mono I get an Array index out of range exception on =
adapter.Fill

Any suggestions?



---------------------------------------------------------------
http://www.videomax.ro/  -  Cautam cinefili pentru premiere!

------=_NextPart_000_008C_01C49102.D37CA560
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT face=3DArial size=3D2>I use the =
following piece=20
of code.</FONT></DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>///</FONT></DIV>
<DIV><FONT size=3D1>
<P><FONT size=3D2>Remoting.BackupDataSet data;</FONT></P>
<P></FONT><FONT size=3D2>data=3D<FONT color=3D#0000ff>new</FONT>=20
Remoting.BackupDataSet();</FONT></P>
<P><FONT size=3D2>String =
connectionString=3D"Database=3Ddionbackupserver;Data=20
Source=3D192.168.90.2;User Id=3Droot;Password=3D";</FONT></P>
<P><FONT size=3D2>String commandText=3D"SELECT=20
UserID,Name,Serial,DateIssued,DateStart,DateEnd,Trial,DiskSpace FROM=20
users";</FONT></P>
<P><FONT size=3D2>MySqlDataAdapter adapter=3D<FONT =
color=3D#0000ff>new</FONT>=20
MySqlDataAdapter(commandText,connectionString);</FONT></P>
<P><FONT size=3D2>adapter.Fill(data.Users);</FONT></P>
<P><FONT =
size=3D2>MessageBox.Show(data.Users.Rows.Count.ToString());</FONT></P>
<P><FONT size=3D2>///</FONT></P>
<P><FONT size=3D2>I use the ByteFX components for connecting to =
MySQL</FONT></P>
<P><FONT size=3D2>Remoting.BackupDataSet is a strong typed DataSet that =
contains=20
the table Users</FONT></P>
<P><FONT face=3DArial size=3D2>On windows these piece of code works =
ok.</FONT></P>
<P><FONT face=3DArial size=3D2>On linux with mono I get an Array index =
out of range=20
exception on adapter.Fill</FONT></P>
<P>Any suggestions?</P></DIV></FONT></DIV>
<BLOCKQUOTE></BLOCKQUOTE>
<BLOCKQUOTE></BLOCKQUOTE>
<BR>
<BR>
<HR>
<a href=3D"http://www.videomax.ro/NewsLetter/Step1.asp"><b>Cautam cinefili pentru premiere!</b></a><br>
<a href=3D"http://www.videomax.ro/">Videomax.ro</a> pune la bataie 172 premii in valoare de 117 milioane lei. Intra si tu in competitie!

</BODY></HTML>

------=_NextPart_000_008C_01C49102.D37CA560--