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