DateTime Null Error, While assigning Null Date Value

pbala

Expand|Select|Wrap|Line Numbers

 ConnectionString = "....."

QueryString = "SELECT * FROM SomeTable"
 
Dim myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString)

Dim myCommand As New MySql.Data.MySqlClient.MySqlCommand(QueryString, myConnection)

Dim myReader As MySqlDataReader
 
Try

myConnection.Open()

myReader = myCommand.ExecuteReader

Dim Field1,Field2 as String

Dim Field3 as Datetime

While myReader.Read

Field1 = myReader.Item ("Field1")

Field2 = myReader.Item ("Field2")

Field3 = myReader.Item ("DateField")

End While
 
'Close the connection

myReader.Close()

myConnection.Close()
 
Catch exEvent As Exception
 
'Do Something
 
End Try

Error Occured.... while DateField is Null in DataBase....
How do i set DateField to Null in my Code

thanks in advance,

tlhintoq

Are you trying to send a null to the database?
Or are you asking how to react if you receive a null from the database?

Are you sure your database "DateField" is really of a type Datetime?
It could be the database is holding that value as a string and you need to parse it.

But you can't assign a null to a datetime. It is already a null if created without giving it a value. If you want to keep it a null, don't change it.

DateTime Null Error, While assigning Null Date Value

re: DateTime Null Error, While assigning Null Date Value

Similar ASP.NET bytes

/bytes/development

/bytes/it

/bytes/about