巧实例：如何在.NET中访问MySQL数据库

try
{
 string constr = "DSN=MySQL;" + "UID=;" +"PWD="; ;
 conn =  new OdbcConnection(constr);
 conn.Open();
 string query = "insert into test.dbtable values10,'disksidkfsdi', 'asdfaf', 'adsfasdf')";
 string tmp = null;
 OdbcCommand cmd = new OdbcCommand(query, conn);
 for(int i = 0; i < 100000; i++)
 {
  cmd.ExecuteNonQuery();
 }
 cmd.Dispose();
 conn.Close();
 query = "select * from test.dbtable";
 OdbcCommand cmd2 = newOdbcCommand(query, conn);
 conn.Open();
 OdbcDataReader reader = cmd2.ExecuteReader();
 while(reader.Read())
 {
  tmp = reader[0].ToString();
  tmp = reader[1].ToString();
  tmp = reader[2].ToString();
  tmp = reader[3].ToString();
 }
 conn.Close();
 query = "delete from test.dbtable";
 OdbcCommand cmd3 = newOdbcCommand(query, conn);
 conn.Open();
 cmd3.ExecuteNonQuery();
 }
 catch(Exception ex)
 {
  MessageBox.Show(ex.Message);
 }
 finally
 {
 conn.Close();
}