Click here to Skip to main content
12,242,449 members (58,493 online)
Rate this:
 
Please Sign up or sign in to vote.
i have this gridview, and i use sqldatasource

this is my select command

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

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 31-Jan-12 1:22am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

@LessonDateID is probably of varchar type.

Try using CAST or CONVERT and convert[^] this varchar to DateTime.
  Permalink  
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


Advertise | Privacy | Mobile
Web01 | 2.8.160426.1 | Last Updated 31 Jan 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100