I found the problem, well kinda. After a lot of researching it seems the MySQL .NET Connector v1.04 has a problem updating column fields of the float (double) datatype. I am working around this problem by performing database updates utilizing the MySQlCommand.ExecuteNonQuery method instead of the MySqlDataAdapter.update(dataset) method, which was much slicker and I wish MySQL would fix this. Anyway, I am looking forward to making an "alpha" version of my database editing tool available this weekend now that it it's basic functions are working.
|