Problems retreiving a date from MySql

[PKin via DotNetMonster.com]

Hi,

I am trying to retreive a record from a MySql table and I get this error
telling :

Unable to convert MySQL date/time value to System.DateTime

I am user the following command:
MySqlDataAdapte r.Fill(MydataSe t, strTable)

And one of the fields is declared as DateTime.

Can anyone help?

Regards PKin.
--
Message posted via http://www.dotnetmonster.com

[Chris]

PKin via DotNetMonster.c om wrote:

Hi,

I am trying to retreive a record from a MySql table and I get this error
telling :

Unable to convert MySQL date/time value to System.DateTime

I am user the following command:
MySqlDataAdapte r.Fill(MydataSe t, strTable)

And one of the fields is declared as DateTime.

Can anyone help?

Regards PKin.

There is a MySQLDataType.M ySqlDateTime that you should use instead of
System.DateTime . You can do a MySqlDateTime.D ateTime (or might be
GetDateTime can't remember) to get a DateTime object from a mysql
database.

Hope it helps
Chris

[PKin via DotNetMonster.com]

Hi Chris,
How can I combine :
MySqlDataAdapte r.Fill with MySqlDateTime.G etDateTime.

You see I get the error when I try to fill the dataset. Here is the code

Dim adapter As New MySqlDataAdapte r
Dim MydataSet As DataSet = New DataSet
Dim myConnection As New MySqlConnection (myConnString)
<Create the connection string and the query string>

Dim myCommand As New MySqlCommand(St rQuery, myConnection)
myConnection.Op en()

adapter.SelectC ommand = New MySqlCommand(St rQuery, myConnection)
adapter.Fill(My dataSet, strTable)
<strTable is the name of the table used in the query sting>

Regards
PKin
--
Message posted via http://www.dotnetmonster.com

[Chris]

PKin via DotNetMonster.c om wrote:

Hi Chris,
How can I combine :
MySqlDataAdapte r.Fill with MySqlDateTime.G etDateTime.

You see I get the error when I try to fill the dataset. Here is the code

Dim adapter As New MySqlDataAdapte r
Dim MydataSet As DataSet = New DataSet
Dim myConnection As New MySqlConnection (myConnString)
<Create the connection string and the query string>

Dim myCommand As New MySqlCommand(St rQuery, myConnection)
myConnection.Op en()

adapter.SelectC ommand = New MySqlCommand(St rQuery, myConnection)
adapter.Fill(My dataSet, strTable)
<strTable is the name of the table used in the query sting>

Regards
PKin

I've never done that... I've always used a datareader and loaded up the
datatable myself. Then it really doesn't become an issue.

Sorry
Chris

[needin4mation]

http://www.google.com/search?sourcei...%2EDateTime%22

I found where the connection string was altered. it is in one of the
first three links, but you may have to follow the thread.

[PKin via DotNetMonster.com]

Thanks guys.

That works very nice with the datareader

PKin
--
Message posted via DotNetMonster.c om
http://www.dotnetmonster.com/Uwe/For...p-net/200510/1