Connecting to a mySQL database using asp.net

Question

So after some tries I figured out I needed a driver for this. I've installed the Components from the links below. But I still can't find any SQL references when I try to add them? I'm wondering if anyone would know the reason for this? I just started with asp.net. I've found several other questions regarding code for connecting but I can't find anyone who've had trouble with the Connector/components before?

MYSQL connector http://dev.mysql.com/downloads/connector/net/5.0.html

Microsoft Data Access Components (MDAC) 2.8 http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

I am using Visual Studio.

Sarwar Erfan · Accepted Answer · 2011-02-20 09:59:34Z

16

Right click on References, then select "Add Reference". Browse and select Mysql.Data.dll.

The dll should be found in the installation directory of the connector you downloaded.

enter image description here

Finally, in code:

using MySql.Data.MySqlClient;

And, sample connection:

MySqlConnection connection = new MySqlConnection("Database=database_name;Data Source=server_domain_or_ip;User Id=mysql_user;Password=mysql_password");
connection.Open();

MySqlCommand command =  connection.CreateCommand();
command.CommandText = "select * from mytable";
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
  //reader.GetString(0)
  //reader["column_name"].ToString()
}
reader.Close();

answered Feb 20, 2011 at 9:59

Sarwar Erfan

18.1k5 gold badges48 silver badges57 bronze badges

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

6 Comments

Peter Rasmussen Over a year ago

I deleted my last comment, I think I've found the problem. It might be the Host that only accept connections locally (the mysql is on my website and my program is on my computer). I'll test this code on another mysql database this evening.

Sarwar Erfan Over a year ago

if you are using 3rd party hosting, they by default accept connection to mysql from localhost only. Some provide you the option in the control panel to add some external IP's to accept incoming connection. If your pc does not have a fixed IP, then it may be a problem. Because, on serverside, you may have to allow incoming connection to mysql from all IP. Which is not good in regard of security. In this case, best option is to develop a webservice on server, which will access database. Then, from desktop app, get data via web service (and no direct db connection)

Sarwar Erfan Over a year ago

Also, you have to hardcode your mysql server password in your app, which anyone can get by simply decompiling the exe. Again, what if you need to change the mysql server password? Or database schema?

Peter Rasmussen Over a year ago

Before I went here I found a nice example where the connection string is saved in the web.config file (using asp.net) - This should do so that not everyone can get it unless I am mistaken? currently security is not my issue it's the connection. I contacted the place where i host my website and the database only accept connections locally. So now I'm looking for a new webhost :) Thank you for your answers they've been really helpful!

Sarwar Erfan Over a year ago

If your project is a website then it is absolutely fine :) I thought you were connecting to mysql from some desktop application.

|

Bhargav Rao · Accepted Answer · 2019-02-09 20:49:21Z

0

You can browse to the DLL and add a reference.

edited Feb 9, 2019 at 20:49

Bhargav Rao

52.6k29 gold badges130 silver badges142 bronze badges

answered Feb 20, 2011 at 0:23

Puneet

1,0141 gold badge8 silver badges14 bronze badges

Collectives™ on Stack Overflow

Connecting to a mySQL database using asp.net

2 Answers 2

6 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Linked

Related