how to access column of date/time data type from ms access

[jaya3000]

hi , when i try to display a column from database (ms access) which is of date/time data type by selecting date from combo box using this statementsql = " select * from myTable where date_id=' " & cboDate.SelectedItem & " ' "it reports the following errorAn unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dllAdditional information: Cast from type 'DataRowView' to type 'String' is not valid. after that ,when i try this one it takes only date not time ,but i want to display both date and time how to change this format to take both date and time'sql = " select * from myTable date_id='" & CDate(cboDate.Text).ToString("MM/dd/yyyy") & "'"please help me

 

[vis781]

That is a bit difficult to read. Could you tidy it up a bit and i'll see what i can do.

 

[kulrom]

Hey please don't duplicate the same thread http://www.vbdotnetforums.com/showthread.php?t=9883
Take a look at the link i attached in the previous thread and answer to my questions there.