Re: Where is Connector/NET Documentation

[David]

Your connection string should read as follows:

myCommand.ConnectionString = "Database=dbName;Data Source=serverName;User Id=userId;Password=pwd;"

The syntax of that string is very important.

Don't change the order of your connection commands. Best practices dictate that your connection should be open for as little time as possible. You should declare and instantiate all of your objects first, then open the connection, run the query, and close your connection. This will keep your application running much more smoothly than opening your connection and leaving it open while your code does a bunch of other stuff.

There is documentation included with the .NET connector that shows the syntax of all the commands available. If you installed the connector to its default location on a Windows box, you can access the documentation by going to: Start>Programs>MySQL Connector Net 1.0.3>Documentation.

David