Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
I am entering datetime in runtime in text format, but when it is getting inserted in sql server database, showing error
that cant convert char datatype to datetime format.
 
i have used format(datetimepicker.value)
 
but still showing error.
 
Can anyone help?
 
i will be obliged
thanks in advance.
sudeshna
Posted 7-Jul-13 20:58pm
Edited 8-Jul-13 19:58pm
v2

1 solution

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

Solution 1

You can do it in two ways....
 
one from code behind and second from sql server
 
1)
DateTime Dob = Convert.ToDateTime(TextBox2.Text);
 
2)
SELECT convert(datetime,'2004-08-24',120)
  Permalink  
Comments
sudeshna from bangkok at 8-Jul-13 3:03am
   
Thanks a lot. problem solved
Nirav Prabtani at 8-Jul-13 3:04am
   
please up vote this solution if you satisfied with it...:)
sudeshna from bangkok at 9-Jul-13 0:27am
   
sir, i had written the code convert.todatetime(datetimepicker.value) but still again showing same error. cant convert char to datetime datatype format
 
can you help me again plz

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

  Print Answers RSS
0 OriginalGriff 520
1 Maciej Los 205
2 Suvendu Shekhar Giri 159
3 Peter Leow 140
4 Kornfeld Eliyahu Peter 133
0 Sergey Alexandrovich Kryukov 9,623
1 OriginalGriff 8,895
2 Peter Leow 5,044
3 Kornfeld Eliyahu Peter 3,333
4 Maciej Los 2,561


Advertise | Privacy | Mobile
Web04 | 2.8.150327.1 | Last Updated 9 Jul 2013
Copyright © CodeProject, 1999-2015
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