Unable to Convert MySql Date/Time value to System.DateTime

[Juan D. Guzman]

Hello all,

I am receiving the above mentioned error when trying to query my db table. If I omit all of the null date/time columns everything works, otherwise the query fails and returns the above error. Is there anyway to get this query to work without omitting the null columns? Any help would be greatly appriciated.

Regards,

JD

Here is the code that I am using:

Private Sub txtCustomerID_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtCustomerID.Leave
Try
Dim strSelectCustomerInfo As String = _
"Select * from tblCustomer" _
& " where CustomerID = 1001"
Dim strConnectString As String = _
"Database=ffsdbold;Data Source=localhost;User ID=dbuser;Password=password"
Dim daCustomerInfo As New MySqlDataAdapter (strSelectCustomerInfo, strConnectString)
Dim dsCustomerInfo As New DataSet
daCustomerInfo.Fill(dsCustomerInfo)
dgdDisputingOverview.DataSource = dsCustomerInfo.Tables(0)
Catch ex As MySqlException
Debug.WriteLine(ex.Message)
End Try
End Sub



Edited 2 time(s). Last edit at 10/03/2005 11:20AM by Juan D. Guzman.