Connecting C# to MYSQL database?

Question

So i been trying to connect C# windows from to MYSQL database, i tryed many different methods that i found online but none seems to be working. here is my code please help (keep in mind this is the first time i use database before).

Here is the connecting class

class DbConnect
{
    public static void DBConnect()
    {
        string connstr = 
        "server=localhost;user=root;database=login;port=3306;password=Password";

        MySqlConnection conn = new MySqlConnection(connstr);

        try
        {
            conn.Open();
        }
        catch
        {
            Console.WriteLine("went rong");
        }
    }

}

Here is the windows form im using

private void btnenter_Click(object sender, EventArgs e)
 {
      DbConnect.DBConnect();
      MySqlCommand query = new MySqlCommand("INSERT INTO logininfo (username, 
      password) VALUES(@username, @password");
        try
        {
            query.Parameters.AddWithValue("@username", txtusername.Text);
            query.ExecuteNonQuery();
            MessageBox.Show("S");
        }

        catch (Exception )
        {
            MessageBox.Show("something went wrong");
        }
        finally
        {
            DbConnect.DBClose();
        }

    }

Don't you have to assign the connection to the MySqlCommand object? — mellamokb
– mellamokb, Commented Apr 3, 2014 at 20:30
Show us what you tried so far and what specific problems you encountered. — Xaver Kapeller
– Xaver Kapeller, Commented May 3, 2014 at 2:25

Habib · Accepted Answer · 2014-04-03 20:28:43Z

2

User is passed in MySQL connection string using Uid. So your connection string should be like:

"server=localhost;Uid=root;database=login;port=3306;password=tro63jans";

You may see: MySQL connection string.

You should also catch exception in some object, so that you can get the details about the exception. Currently you are not showing any useful message from your exception.

catch (Exception ex) //at least
{
    MessageBox.Show("something went wrong: " + ex.ToString());
}

answered Apr 3, 2014 at 20:28

Habib

224k30 gold badges420 silver badges446 bronze badges

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

2 Comments

user3487107 Over a year ago

Ok so i changes the uid and still did not work, im making the exception now to see what else is wrong

user3487107 Over a year ago

Connection must be vail and open is what its saying, so something is wrong with the connection

Kyle Hale · Accepted Answer · 2014-04-03 20:33:30Z

1

One problem you have here is you're not setting the Connection property of your MysqlCommand to the MySqlConnection you're making earlier.

Change DBConnect() to return your MySqlConnection.
Set your MySqlCommand's Connection property to the returned value.

PSEUDO-CODE

MySqlConnection conn = DBConnect.DBConnect();
 MySqlCommand command = new MySqlCommand(commandStr, conn);
command.ExecuteNonQuery();
conn.Close();

answered Apr 3, 2014 at 20:33

Kyle Hale

8,1301 gold badge40 silver badges59 bronze badges

2 Comments

user3487107 Over a year ago

What type of return does it need, just a boolean?

Kyle Hale Over a year ago

No, it should return a MySqlConnection object (specifically your conn instance.)

Collectives™ on Stack Overflow

Connecting C# to MYSQL database?

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related