Using MySQL 5.0 with MS.NET

Installing MySql and Connector/Net

1. Go to www.mysql.com website.
2. Select MySQL 5.0 Community Server
3. Select download link and select "Windows Essentials(x86)"
4. After file is downloaded, double click on .msi file and start installing MySQL 5.0
5. Connect to MySQL using MySQL -> MySQL Server 5.0 -> MySQl Command Client
6. When it prompt you to enter password, just enter password that you gave at the time of installation for "root" user
7. Give "Use MySQL" command at "MySql>" command prompt
8. You are now connected to MySQL database
9. Create some tables and other objects. For syntax details, see MySQL Manual using MySQL->MySQL Server 5.0-> MySql Manaual.

1. Select Download link and then select Connectors link in the home page of MySql.com
2. Select "Connector/Net" link
3. Select "Windows Source and Binaries (ZIP)"
4. Unzip .ZIP file to get .MSI file and install it by double clicking on it.

Connect to MySQL using .NET

1. Go to solution explorer and select Add References option from Popup (Context) menu
2. From Add References dialog box, select "MySQL.Data" option and click on Ok.
3. Write the following code to connect to MySQL and modify data in ADDRESSES table, which was created by me in MySQL Database. In your case, you must create this table on your own.

using System;
using MySql.Data.MySqlClient;  // required for MySQL

namespace MySQLDemo
{
    class ChangeEmail
    {
        static void Main(string[] args)
        {
            MySqlConnection con = new MySqlConnection("server=localhost;Database=mysql;Uid=root;Pwd=srikanth");
            try
            {
                con.Open();
                // parameters are created with ? followed by a name - ?email
                MySqlCommand cmd = new MySqlCommand("update addresses set email = ?email where name =
                    ?name", con);
                cmd.Parameters.Add("?email", MySqlDbType.VarChar, 50).Value = "srikanthpragada@yahoo.com";
                cmd.Parameters.Add("?name", MySqlDbType.VarChar, 30).Value = "P.Srikanth";
                if (cmd.ExecuteNonQuery() == 1)
                    Console.WriteLine("Updated Successfully");
                else
                    Console.WriteLine("Name Not Found");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error-->" + ex.Message);
            }
            finally
            {
                con.Close();
            }
        } // end of main
    }
}