Click here to Skip to main content
16,014,568 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi all,



In my project I am using datetime picker if I select after 9 days from todays date it shows an exception like this(The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.) how can I rectify this exception please help me.

Thanks in Advance.
Posted
Updated 3-Aug-11 22:10pm
v2
Comments
Suresh Suthar 4-Aug-11 4:47am    
Where is the error coming? Means, while selecting date or while inserting in database? Can you please post the error message?
Suresh Suthar 4-Aug-11 4:50am    
I think the error is while updating/inserting data in database and you are not using parametrized query.
Karwa_Vivek 4-Aug-11 8:06am    
post your Code

1 solution

Hello,

Well change the dateformat.

thanks
sanjeev
 
Share this answer
 
Comments
rrrer 4-Aug-11 4:15am    
Hai Friend ,

I change the date format,But it Shows the same exception ..
Thanks
rajesh
[no name] 8-Aug-11 5:46am    
what you have did exactly will you let me know
[no name] 15-Aug-11 0:00am    
please explain exactly what you want.

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



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