C# .NET - what are the procedure to remote mysql database with c#.net

Assuming that you know how to connect to and query a database, you'll need the following:

1. The http://dev.mysql.com/downloads/connector/net/5.2.html
2. The hostname or IP address of the server
3. A user ID and password to connect with

Add a reference to the MySQL provider. From there, it works just like connecting to a SQL Server box, except the class names are a bit different and some minor SQL dialect is also different.

Of course, if you don't already know how to connect to a database, you'll need to start a bit slower. I'd recommend you Google yourself a http://www.google.com/search?rlz=1C1CHMB_enUS291US303&ie=UTF-8&q=ADO.NET+tutorial.

I got solution i this
link- 

 

 http://stackoverflow.com/questions/402355/connect-to-remote-mysql-database-with-visual-c



Try this
code-


 



using System;
using System.Collections.Generic;
using
System.Linq;
using
System.Text;
using MySql.Data.MySqlClient;
namespace
ConsoleApplication1
{
 
  class Program

    {




     
  static void Main(string[]
args)
     
  {
   
        Console.WriteLine("Welcome ...!");
         
  String conString
= "SERVER = localhost; DATABASE = l2emu; User ID = root; PASSWORD =
password;";

 
      MySqlConnection  connection =
new MySqlConnection(conString);

            String command = "SELECT * FROM
characters";
   
      MySqlCommand  cmd =
new MySqlCommand(command,connection);
MySqlDataReader
reader;
try
{
    connection.Open();
    cmd.ExecuteNonQuery();
    reader = cmd.ExecuteReader();
    cmd.CommandType = System.Data.CommandType.Text;
 
  while (reader.Read() != false)
 
  {

   
    Console.WriteLine(reader["char_name"]);
       
Console.WriteLine(reader["level"]);

    }

    Console.ReadLine();

}
catch (MySqlException MySqlError)
{
 
  Console.WriteLine(MySqlError.Message);
}

 
      }
    }
}



Hope this will help you.