c# and mysql datetime
- From: "oscar" <oscar@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Jun 2005 07:07:01 -0700
currently i'm writing a ADO.Net program using C3 and mysql. i am using
crystal reports by running a mysql query into a DataSet and then using the
DataSet.WriteXMLSchema() function. The problem i'm having is that when i
write the xml schema the mysql datetime column shows up as:
<xs:element name="datesold" msdata:DataType="MySql.Data.Types.MySqlDateTime,
MySql.Data, Version=1.0.4.29851, Culture=neutral, PublicKeyToken=null"
type="xs:string" minOccurs="0" />
and crystal reports does not recognize it in the schema. Is there a way to
change the column?
i tried changing the column type in the dataset but can't change the type
after it's filled. i know i could copy all the data into a datatable, but
there are going to be about 20,000 records in the dataset, so i don't want to
dump the xml or have to run a loop to import it into a datatable.
thanks in advance for any help,
scott
.
- Prev by Date: Re: Syntax error (missing operator) when delete with Commandbuider
- Next by Date: How to check if filled ?
- Previous by thread: Want to write your SQL statements and even stored procedures in pure C#?
- Next by thread: How to check if filled ?
- Index(es):
Relevant Pages
|
