要看是什么错误,我才是nullpointerexception,使因为没有结果集。

解决方案 »

  1.   

    看看:连接MySQL 
      A.ODBC 
        I.Local database:
          "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;" 
        II.Remote database:
          "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;
          Stmt=;Database=my-database;Uid=username;Pwd=password;" 
      B.OLE DB, OleDbConnection (.NET) 
        I.Standard:
          "Provider=MySQLProv;Data Source=mydb;User Id=UserName;
          Password=asdasd;" 
      C.MySqlConnection (.NET) 
        I.eInfoDesigns.dbProvider:
          "Data Source=server;Database=mydb;User ID=username;
          Password=pwd;Command Logging=false" 
          注:此写法仅用于通过eInfoDesigns dbProvider连接:
        II.声明方法:
          C#:
          using eInfoDesigns.dbProvider.MySqlClient;
          MySqlConnection oMySqlConn = new MySqlConnection();
          oMySqlConn.ConnectionString = "my connectionstring";
          oMySqlConn.Open(); 
          VB.NET:
          Imports eInfoDesigns.dbProvider.MySqlClient
          Dim oMySqlConn As MySqlConnection = New MySqlConnection()
          oMySqlConn.ConnectionString = "my connectionstring"
          oMySqlConn.Open()