String was not recognized as a valid DateTime. ?
hi guys,
i'm trying to display date format.....
its fine working in SQL giving output but
getting the error in webpart (Sharepoint webpage)...wat can i do ?
May 18th, 2010 7:34pm
Could you please share us more information?
Which web part did you refer in your post? How did you show the date?
Was the date from other data non-SharePoint database?Sincerely,
Lambert Qin
Posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2010 4:48am
I Created the webpart with User Control from Visual Studio C#.net adding the webpart to sharepoint website
used the same SQL query adding a bit of data bindig code to it.
i've shown the date in 2010:05:20 09:11:29:233 as i'm using SQL Server-2008 like a stored proc query.
donno y it's not comin..
S
May 20th, 2010 10:44am
Sorry pls unpropose, got clicked by mistake.
Coming back to your question: Could you please tell what error are you receiving?
Paste the same here.BR, PM
Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2010 8:59pm
I Created the webpart with User Control from Visual Studio C#.net adding the webpart to sharepoint website.
I used the SQL query + data bindig code for representing webpart functioning in sharepoint page
Here, i executed query containing date as 2010:05:20 09:11:29:233 in SQL Server-2008 like a stored proc query.
But this stored procedure query is gettign an error "String was not recognized as a valid DateTime."
no clue, y it is comin..! any ideas..?
S.
June 3rd, 2010 9:47pm
Please have a look at these links for help:
http://www.sql-server-helper.com/tips/date-formats.aspx
http://weblogs.sqlteam.com/jeffs/archive/2007/04/13/format-date-sql-server.aspxBR, PM
Free Windows Admin Tool Kit Click here and download it now
June 6th, 2010 11:38pm