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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics