Comments by Member 14075800

Member 14075800 3-May-19 9:47am View

I tried. and same error occurred. Anyway, still thanks you much.

Member 14075800 3-May-19 9:40am View

Alright, it's okay. thanks again.
I feel really confuse, as I tried to use the exactly same code in a new web form, it can be inserted well without any conversion error. But back to the real web form, it comes out with the error.. I got really no idea for it, maybe I should check again.. hmm...

Member 14075800 3-May-19 9:18am View

I see... thank you for the information. Means that I shouldn't convert them to short time string?

Member 14075800 3-May-19 9:15am View

Thanks, I had just tried, but it tells that "String was not recognized as a valid DateTime" ...

Member 14075800 3-May-19 9:14am View

Thanks for the suggestion, I'm still finding way to solve it.

Member 14075800 16-Apr-19 11:13am View

Thanks for your reply :) "cal_schedule_view" is the calender id with the selected date. I saved [classStart] as DATETIME in my database, that is why I need to get only the date of [classStart]... The query did run well without this... "WHERE CONVERT(VARCHAR,[classStart],101) = '" + cal_schedule_view.SelectedDate + "'"

May I know is ado.net the only the way to solve this?

Comments by Member 14075800 (Top 6 by date)