[Mono-list] System.Data.DataTable+ByteFX

Mon, 19 Jan 2004 19:05:58 -0600

This is a multi-part message in MIME format.

------=_NextPart_000_0019_01C3DEBF.45D91400
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

The value returned, and thus the object in the DataTable, is a DateTime
object.  .ToString() on the DateTime object in the en-us culture shows =
in
MM/DD/YYYY 00:00:00 format.  To show in another format, you can use the
normal .NET formatting routines.

=20

-reggie

=20

  _____ =20

From: mono-list-admin@lists.ximian.com
[mailto:mono-list-admin@lists.ximian.com] On Behalf Of felipe maya
Sent: Saturday, January 17, 2004 6:34 PM
To: mono-list@ximian.com
Subject: [Mono-list] System.Data.DataTable+ByteFX
Importance: High

=20

When I use a SELECT command with MySqlAdapter the data is filled in a
DataTable. Why the mysql date format "YYYY-MM-DD" change to "MM/DD/YYYYY
00:00:00" when the data is filled in a DataTable. How i can change it?

  _____ =20

Consigue tu correo GRATIS en Manizales.com,
dale vida a tus mensajes con m=E1s de 300 motivos graficos.
Busca el portal de tu ciudad en http://www.enredese.net
_______________________________________________ Mono-list maillist -
Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list=20

------=_NextPart_000_0019_01C3DEBF.45D91400
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>

<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
 namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"time"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"date"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

The value returned, and thus the =
object in
the DataTable, is a DateTime object. &nbsp;.ToString() on the DateTime =
object
in the en-us culture shows in MM/DD/YYYY 00:00:00 format. &nbsp;To show =
in
another format, you can use the normal .NET formatting =
routines.<o:p></o:p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>-reggie<o:p></o:p></span></font></p>=

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in =
0in 4.0pt'>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
mono-list-admin@lists.ximian.com =
[mailto:mono-list-admin@lists.ximian.com] <b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>felipe maya<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Saturday, <st1:date
Year=3D"2004" Day=3D"17" Month=3D"1" ls=3D"trans" w:st=3D"on">January =
17, 2004</st1:date>
<st1:time Minute=3D"34" Hour=3D"18" w:st=3D"on">6:34 PM</st1:time><br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
mono-list@ximian.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Mono-list]
System.Data.DataTable+ByteFX<br>
<b><span style=3D'font-weight:bold'>Importance:</span></b> =
High</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

When I use a SELECT command with
MySqlAdapter the data is filled in a DataTable. Why the mysql date =
format
&quot;YYYY-MM-DD&quot; change to &quot;MM/DD/YYYYY 00:00:00&quot; when =
the data
is filled in a DataTable. How i can change =
it?<o:p></o:p>

<div class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:black'>

<hr size=3D2 width=3D350 style=3D'width:262.5pt' noshade =
color=3D"#facb65" align=3Dleft>

</span></font></div>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:black'>Consigue tu correo GRATIS en =
<b><span
style=3D'font-weight:bold'><a =
href=3D"http://manizales.com">Manizales.com</a></span></b>,<br>
dale vida a tus mensajes con m&aacute;s de 300 motivos graficos.<br>
Busca el portal de tu ciudad en <a href=3D"http://www.enredese.net"
target=3D"_blank">http://www.enredese.net</a><br>
_______________________________________________ Mono-list maillist -
Mono-list@lists.ximian.com =
http://lists.ximian.com/mailman/listinfo/mono-list =
</span></font><o:p></o:p></p>

</div>

</div>

</body>

</html>

------=_NextPart_000_0019_01C3DEBF.45D91400--