Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting dates from SQL into C# DateTime objects
Message
De
16/07/2004 13:58:34
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
 
À
15/07/2004 19:47:42
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
00924961
Message ID:
00925278
Vues:
12
>I can't figure out how to convert datetime field from Microsoft SQL Server into a C# DateTime object. I have found the DateTime.Parse and DateTime.ParseExact methods, but can't really figure out IFormatProvider. Once I have the string from Microsoft SQL, I would expect that, since it was a commonly used format, there would be an easy way, I just can't find it.
>
>(I just want to dump the datum from the database into a DateTime object. I don't have to worry about formatting it's output now.)

David,

Do you mean that the field in your SQL Server table is varchar? If it is DateTime, the SQL ADO.NET provider performs the conversion automatically.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform