>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()......