复制try{string constr = "DSN=MySQL(和PHP搭配之最佳组合); " + "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(); } 1.2.3.4.5.6.7.8.9.10.11.12.13.
