Mary Chipman [MSFT]
8/28/2009 2:38:00 PM
I don''t know anything about MySQL, but the same rules apply for any
server database -- perform data processing on the server using
set-based commands (SQL), not in client code. If you are migrating
from a VBA/Access front-end, you will have no further use for DAO. I''d
recommend getting David Sceppa''s "ADO.NET" book (Microsoft Press),
which will teach you how to do data access the .NET way. It has
examples in both C# and VB, which will be helpful in learning C# since
you are coming from the VBA world. HTH,
--Mary
On Tue, 25 Aug 2009 14:50:30 +0200, "Miha Abrahamsberg" <miha@krik.si>
wrote:
>Hi!
>
>I''m new to C#.NET , but I have a lot of experience in VBA (MsAccess).
>
>What would be the best way (ODBC, OleDb...) to connect from C#.NET (windows
>forms) to a remote MySQL database server and work with date (Select, update,
>delete, insert...) ?
>
>note: I''m used to working with DAO or passing action SQL queries in
>VBA/Access
>
>Thank you in advance!
>
>Miha
>