Click here to Skip to main content
15,885,366 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i have this gridview, and i use sqldatasource

this is my select command

HTML
SELECT Date.dateAvailable FROM LessonDate INNER JOIN Date ON LessonDate.dateID = Date.dateID WHERE (LessonDate.lessonID = @lessonID)

however when i want to update the dateAvailable column

HTML
UPDATE       Date
  SET                dateAvailable = @dateAvailable
  FROM            Date INNER JOIN
                           LessonDate ON Date.dateID = LessonDate.dateID
  WHERE        (LesssonDate.dateID = @LessonDateID)


however it when i click on excute query it give me error conversion failed when converting date and/or time from character string

so what wrong?
Posted

1 solution

@LessonDateID is probably of varchar type.

Try using CAST or CONVERT and convert[^] this varchar to DateTime.
 
Share this answer
 
v3
Comments
cutexxbaby 31-Jan-12 6:35am    
can you show me how?
Abhinav S 31-Jan-12 6:38am    
Try convert(datetime, @LessonDateID).
cutexxbaby 31-Jan-12 6:40am    
you mean the LessonDateID not the dateAvailable
Abhinav S 31-Jan-12 6:45am    
Try both.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900