>>Hi
>>
>>I'm converting some code from SQL Express to Mysql
>>
>>and I'm getting the following error
>>
>>Overload resolution failed because no Public 'toReadable' can be called with these arguments: 'Public Shared Function toReadable(d As Date) As String': Argument matching parameter 'd' cannot convert from 'Byte()' to 'Date'. 'Public Shared Function toReadable(value As String) As String': Argument matching parameter 'value' cannot convert from 'Byte()' to 'String'."}
>>
>>In this code
>>
>>

>>               Dim dtMonths As DataTable = dataLayerConnector.getDataTable("SELECT distinct pop as Month from vw_stock_month_model order by pop")
>>                For Each row As DataRow In dtMonths.Rows
>>                    Dim li As ListItem = New ListItem(toReadable(row("Month")), row("Month"))
>>

>>
>>I've switched the datalayer to read the mysql data . What should be returned is "200905","200906" etc
>>
>>What would be my basic problem here ?
>
>The basic problem is that toReadAble() can only accept either a Date or String type as a parameter and presumably row("Month") is neither of those. First step is to determine what *is* the type of row("Month") - you can then decide whether to somehow convert it to a date or string or, probably better, to provide an additional overload for toReadable()......

Thanks Viv

I looked through the debug information for dtMonths but couldn't find what had been returned (it should get a string). How would I be able to establish exactly what had been passed back.