error on datagridview date field using mysql and vb2005

[thelner]

Well, the app im working on makes an error when trying to populate a datagridview when the source contains date field. Any solution to my problem?


dgvInvoices.DataSource = richdb.getTableData("Select invoiceno,duedate as string from invoice Where IsCleared = '0' and duedate <= '" & convert.tomysqldatenow & "'")

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

[daniel aristidou]

Well, the app im working on makes an error when trying to populate a datagridview when the source contains date field. Any solution to my problem?
Error: Unable to convert MySQL date/time value to System.DateTime

Try this....

Bindingsource.filter = "Iscleared = '0'" "and duedate <= '" & now & "'"

[thelner]

Thanks but a complete noob here. :)

Where should i place the bindingsource.filter?

Will it allow me to display mysql dates on the datagridview w/o the error?

[daniel aristidou]

Where should i place the bindingsource.filter?

Will it allow me to display mysql dates on the datagridview w/o the error?

Well that depends on you....do you want the datagrid to always only display the corresponding records?
if so.. put it under form_load
else create a command button ..and put it under
commandbotton1_click
I think it will sove your problem...no promises though...if it does not solve the problem...im still around...

[thelner]

Still wont work. Has the same error. I think the error is generated because .net cant display on a datagridview tables that has a diiferent format date field. Is there a way so that .net will interpret mysql date tables as strings?

        Public Sub refreshinvoices()
        Dim source As New BindingSource
        richdb.connectRichDB() 'opens mysql connection
        source.DataSource = richdb.getTableData("Select * from invoice") 'binds invoice table to bindingsource
        source.Filter = "IsCleared = '0'" 'selects uncleared invoices
        dgvInvoices.DataSource = source
        richdb.disconnectRichDB() 'closes connection
End Sub