Use mysql in a C# Windows Application within Visual Studio 2010

Question

I want to know the code which allows my C# Windows Application to use mysql database located on internet with C# in a windows application and run main queries such as delete, insert, select,etc. Please Explain like i am a newbie.

how do you access your mySQL, via IP address? is that your server or your hosting provider server? are you sure the provider allows you to connect to it remotely and not only from a hosted web application? — Davide Piras
– Davide Piras, Commented Jan 25, 2012 at 17:17
possible duplicate of Windows application using MySQL from a webserver — jgauffin
– jgauffin, Commented Jan 25, 2012 at 20:02

juergen d · Accepted Answer · 2012-01-25 19:57:25Z

2

Bind the MySQL .Net Connector in your project and then you can do something like:

using MySql.Data.MySqlClient;

string dbConnectionString = "SERVER=server_address;DATABASE=db_name;UID=user;PASSWORD=pass;";
MySqlConnection connection = new MySqlConnection(dbConnectionString);
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "select name from mytable";
MySqlDataReader Reader = command.ExecuteReader();    
while (Reader.Read())
{
     string name = "";
     if (!Reader.IsDBNull(0))
         name = (string)Reader["name"];
}
Reader.Close();

edited Jan 25, 2012 at 19:57

answered Jan 25, 2012 at 17:20

juergen d

205k40 gold badges305 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BShakiba Over a year ago

I Found It Elsewhere But THANKS! Can You Do Me A Great Favour and answer my next problem Too?? :D

Collectives™ on Stack Overflow

Use mysql in a C# Windows Application within Visual Studio 2010

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related