List:MySQL and .NET« Previous MessageNext Message »
From:Frank Date:November 23 2004 5:18pm
Subject:DataAdapter Update and Connection
View as plain text  
Hi,
I'm working on a Windws Forms application under Windows which connects to a MySQL serer on
Linux 9.0.
I tried filling datasets and executing commands and everything works, apart from an
invalid cast exception on date fields (driver version 1.0.2 only). My problem is when I
change values on a DataRow and launch DataAdapter.Update this way:

//Here conn.State is Closed
conn.Open();
DA.Update();
conn.Close();

The record on the database server gets updated, but I receive an exception (on the Update
line) saying that the connection is already open... If I remove the conn.Open() line
obviously it says that the connection must be valid and open. It looks something goes
wrong in the Update code...
This happens with 1.0.0, 1.0.1 and 1.0.2 driver version.
Thanks,
Frank
Thread
DataAdapter Update and ConnectionFrank23 Nov
  • RE: MySQL Connector/Net 1.0.1 beta 2 has been released.Barry Zubel28 Oct
    • Only byte arrays can be serialized by MySqlBinaryBarry Zubel28 Oct
      • Broken CodeJoshua Mouch28 Oct
        • RE: Broken CodeBarry Zubel28 Oct
          • RE: Broken CodeDarren Hill28 Oct
            • RE: Broken CodeDarren Hill28 Oct
              • RE: Broken CodeBarry Zubel28 Oct
                • RE: Broken CodeDarren Hill28 Oct
                  • RE: Broken CodeBarry Zubel28 Oct
                    • RE: Broken CodeDarren Hill28 Oct
                    • RE: Broken CodeJoshua Mouch28 Oct
                  • RE: Broken CodeReggie Burnett28 Oct
                • RE: Broken CodeJoshua Mouch28 Oct
                  • RE: Broken CodeJoshua Mouch28 Oct
                    • RE: Broken CodeJoshua Mouch28 Oct
                      • RE: Broken CodeReggie Burnett28 Oct
      • RE: Only byte arrays can be serialized by MySqlBinaryReggie Burnett28 Oct
        • An established connection was aborted by the software in your host machineDarren Hill3 Nov
      • RE: Only byte arrays can be serialized by MySqlBinaryBarry Zubel28 Oct
        • RE: Only byte arrays can be serialized by MySqlBinaryReggie Burnett28 Oct
        • RE: Only byte arrays can be serialized by MySqlBinaryReggie Burnett28 Oct