[Mono-list] ByteFX MySql on Mono problem
Dan Cimpoiesu
dan.cimpoiesu@dion.ro
Wed, 1 Sep 2004 10:30:01 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_003C_01C4900E.A3326FB0
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
On windows these piece of code works ok.
On linux with mono I get an Array index out of range exception on =
adapter.Fill
------=_NextPart_000_003C_01C4900E.A3326FB0
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>I use the following piece of =
code.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </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></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></DIV></BODY></HTML>
------=_NextPart_000_003C_01C4900E.A3326FB0--