If you are using the ByteFX provider, the following code will update (check
for compile errors) from a dataset. This will work on .NET but I have not
run code like this on Mono but it should work (or be very close anyway).
MySqlConnection conn = new MySqlConnection("..connecion string here..");
MySqlDataAdapter da = new MySqlDataAdapter(da, "select * from mytable");
DataSet ds = new DataSet();
Da.Fill(ds, "mytable");
Ds.Tables[0].Rows[0]["mycolumn"] = "myvalue";
Ds.Tables[0].Rows[3].Delete()
// now perform the update
MySqlCommandBuilder cb = new MySqlCommandBuilder(da);
Da.Update(ds, "mytable");
For further info you can use the MSDN docs on the SqlClient data provider as
the two work the same. Simply use the classes found in the
ByteFX.MySqlClient namespace.
Reggie
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:mono-list-
> [EMAIL PROTECTED] On Behalf Of Sergio Blanco Cuaresma
> Sent: Sunday, August 24, 2003 7:00 PM
> To: [EMAIL PROTECTED]
> Subject: [Mono-list] DataSets + MySQL
>
> Hi,
>
> Does somebody have some example showing how to connect to a MySQL using
> DataSets ? Is it currently supported by mono?
>
> Thanks!
>
> --
>
> [aka Marble]
> Registered LiNUX user #140941 <> http://counter.li.org/
> Socio #3274 de HispaLinux <> http://www.hispalinux.es
> Miembro de GPL URV <> http://www.gplurv.org
> GnuPG key: 0x0ED2CF9D <> pgp.escomposlinux.org
_______________________________________________
Mono-list maillist - [EMAIL PROTECTED]
http://lists.ximian.com/mailman/listinfo/mono-list
