This is a migrated thread and some comments may be shown as answers.

System.InvalidCastException: Specified cast is not valid.

1 Answer 484 Views
Calendar
This is a migrated thread and some comments may be shown as answers.
GV
Top achievements
Rank 1
GV asked on 19 Nov 2009, 02:16 AM
When I add it to DATABASE I do following

Dim

 

wwctetime1 As Date

wwctetime1=RadDateTimePicker1.Text

cmd.Parameters.Add(

"@wtime1", SqlDbType.Int).Value = Hour(wwctetime1)

Now I want to read from Database and Assigen value back to RadDateTimePicker1

So how I want to do is

 

 

RadDateTimePicker1.SelectedDate = dta.Rows(0)(

"wwctetime1")


In my data base I'm just saving time ex 2, 7, 23,22 etc

 I would really appreciate any help

 

 

 

 

 

 

 

 

 

 

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 19 Nov 2009, 01:27 PM
Hello,

I suppose your database value return int value. Try the following code to set the selected date:
vb:
Dim dt As DateTime = DateTime.Now.[Date
dt = dt.AddHours(dta.Rows(0)("wwctetime1")) 
RadDateTimePicker1.SelectedDate = Convert.ToDateTime(dt)  

Thanks
Princy.
Tags
Calendar
Asked by
GV
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or