Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
C# to MySQl
1 view
Skip to first unread message
Miha Abrahamsberg
Aug 25, 2009, 8:50:30 AM8/25/09
to
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
Mary Chipman [MSFT]
Aug 28, 2009, 10:38:20 AM8/28/09
to
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,
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" <mi...@krik.si>
wrote:
0 new messages