B
BillE
I am importing data in a XML document into a SQL Server database.
Null data in the XML document is represented like this:
<elementname />
But when I load the XML document into a dataset, it becomes an empty string,
which generates an error when I insert the data into the database for
datetime fields.
I load the data into a XMLTextReader, read it into a dataset, and send it to
the database:
XMLTextReader xr = new XMLTextReader (filename.xml);
DataSet ds = new DataSet();
ds.ReadXML(xr);
SQLDataAdapter da = new SQLDataAdapter();
//configure InsertCommand...
da.Update(ds);
When I look at the data in the dataset, null values in elements become empty
strings "". I get:
"Failed to convert parameter value from a String to a DateTime."
Null data in the XML document is represented like this:
<elementname />
But when I load the XML document into a dataset, it becomes an empty string,
which generates an error when I insert the data into the database for
datetime fields.
I load the data into a XMLTextReader, read it into a dataset, and send it to
the database:
XMLTextReader xr = new XMLTextReader (filename.xml);
DataSet ds = new DataSet();
ds.ReadXML(xr);
SQLDataAdapter da = new SQLDataAdapter();
//configure InsertCommand...
da.Update(ds);
When I look at the data in the dataset, null values in elements become empty
strings "". I get:
"Failed to convert parameter value from a String to a DateTime."