CODEWITHSUNDEEP
mysqlvisual-studio
sean
sean

Reputation: 9268

Connecting MySQL with Visual Studio C#

I'm new to MySQL Workbench and I'm trying to make a Timekeeping system. I'm wondering how to connect MySQL with Visual Studio C#?

Upvotes: 6

Views: 49265

Answers (5)

Johnny Oshika
Johnny Oshika

Reputation: 57562

The easiest way is to use NuGet to get the .Net connector for MySQL:

enter image description here

Once you install the MySql.Data package, you can do something like this:

using (var connection = new MySqlConnection("Server=localhost;Database=MyDatabaseName;Uid=root;Pwd=;"))
using (var command = connection.CreateCommand()) {
    connection.Open();
    command.CommandText = "select id, name from widgets";

    using (var reader = command.ExecuteReader())
        while (reader.Read())
            Console.WriteLine(reader.GetString(0) + ": " + reader.GetString(1));
}

Upvotes: 5

codeandcloud
codeandcloud

Reputation: 55248

If you are working with MySQL for the first time in your PC, do these things.

  1. Install MySQL Server (Link here) - 28 MB
  2. Install MySQL ODBC Connector (Link here) - 3 MB

Now install SqlYog Community Edition. ( Link here ). You can manipulate your MySQL Databases using this.

Now in AppSettings of web.config, set two entries like this.

<configuration>
  <appSettings>
    <add key="ODBCDriver" value="Driver={MySQL ODBC 5.1 Driver};Server=localhost;"/>
    <add key="DataBaseDetails" value="Database=mydatabase;uid=root;pwd=;Option=3;"/>
  </appSettings>
</configuration>

And call it like in your MySQL class like this.

public string MyConnectionString 
{
    get
    {
        //return {MySQL ODBC 5.1 Driver};Server=localhost;Database=mydatabase;uid=root;pwd=;Option=3;
        return ConfigurationManager.AppSettings["ODBCDriver"]
            + ConfigurationManager.AppSettings["DataBaseDetails"];
    }
}

Now you can initialize your connection like this.

OdbcConnection connection = new OdbcConnection(MyConnectionString);

Namespace imported

using System.Data.Odbc;

Hope you get the idea.

Upvotes: 6

Devart
Devart

Reputation: 122032

You can connect to MySQL using dotConnect for MySQL.

more information

Upvotes: 2

Jaime
Jaime

Reputation: 6814

you'll need a "connector/driver" to connect from .net to mysql, you can find the official .net connector from mysql here:

http://dev.mysql.com/downloads/connector/net/

the connector will install the MySql.Data library that you has classes to communicate to MySql (MySqlConnection, MySqlCommand, MySqlDataAdapter, etc)

Upvotes: 9

cabanaboy
cabanaboy

Reputation: 71

Try this website:

http://www.connectionstrings.com/mysql#p34

Set up your connection string and then the rest should just work as if you were calling a SQLServer database.

Good luck.

Upvotes: 2

Related Questions