MySqlConnection conn = new MySqlConnection();
string connStr = String.Format("server={0};user={1}; password={2}; database=mysql; pooling=false",
                sServer, sUser, sPassword);
conn.ConnectionString = connStr;

try
  {
    Console.WriteLine("Connecting to MySQL...");
    conn.Open();
    // Perform database operations
  }
  catch (Exception ex)
  {
    Console.WriteLine(ex.ToString());
    return 1;
  }

四、数据库查询语句的执行

string sql = string.Format("SELECT networkperiod, parttype FROM alldb.part WHERE partid = {0}",
                iPartId);

MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();

if (rdr.HasRows)
{
   rdr.Read();

   int iPeriod = rdr.GetInt32(0);
   int iPartType = rdr.GetInt32(1);
}
rdr.Close();