Click here to Skip to main content
13,002,133 members (76,509 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 0:22am

1 solution

Rate this: bad
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.
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.170624.1 | Last Updated 31 Jan 2012
Copyright © CodeProject, 1999-2017
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