StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POThe Conversion Between Dates and Strings in ASP.NET C#
primarykey
Id
6649037
data
AcceptedAnswerId
6649116
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-11T10:56:32.427
FavoriteCount
2
LastActivityDate
2011-07-11T11:03:17.147
LastEditDate
LastEditorUserId
0
OwnerUserId
493325
ParentId
0
PostTypeId
1
Score
2
ViewCount
1185
LastEditorDisplayName
text
Body
I worked now in a dynamic ASP.NET C# web application that connects to a Sybase database using ODBC and my main problem is the conversion between datetime and string data types in my application. The database saves the datetime data in the following form:- <pre><code>7/11/2011 05:05:05 I think it is in the pattern of "MM/dd/yyyy hh:mm:ss" </code></pre> I need to call a web service and pass some datetime parameters to get the correct output. The static datetime format that is accepted by the web service is:- <pre><code>11/07/11 09:09:09 I think it is in the pattern of "dd/MM/yy hh:mm:ss" </code></pre> I tried using the following functions separately <pre><code>string s = d.toString(string format) DateTime d = Convert.ToDateTime(string s) DateTime d = s.Datetime.Parse(string format) DateTime d = s.Datetime.ParseExact(string format) </code></pre> to convert the dates I got from the database to be suitable to be passed to the web service but it always gives me different exceptions like:- Exception:System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.DateTime.Parse(String s) at WebApplication1.WebForm1.callWebservice() I do not know how I should use and convert dates in the proper way and I get disappointed as I try many examples and functions but I can not get the right methodlogy. I hope that I find someone who could help and Thanks in advance.....
Tags
<c#><asp.net><string><datetime>
Title
The Conversion Between Dates and Strings in ASP.NET C#
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTopDeveloper
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POThe Conversion Between Dates and Strings in ASP.NET C#
 UserUserId
 USMark Perry
 VoteTypeVoteTypeId
 VTFavorite
2. VO
 singulars
 PostPostId
 POThe Conversion Between Dates and Strings in ASP.NET C#
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POThe Conversion Between Dates and Strings in ASP.NET C#
 UserUserId
 USslugster
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.