Hi, I have the following problem. When I try to read data out of sql server in put it into a dataset which i write into an xml file i get the following date: <Starting_x0020_Time>1753-01-1T00:00:00.0000000+01:00</Starting_x0020_Time> How can i set an empty value instead of this ? Tnx
You are not very clear… What table? Sample codes? Anyway, I would recommend skipping the first field if you directly access the SQL server table. Which, I believe is the “TimeStamp” field. Don’t even try to update that field, I believe SQL will do that for you.
Move to SQL Server Forum.
maybe you want to use Table created from navision, to use in vb.net… am I Right?
for your information, field timestamp doesn’t work in ADO.net
My Suggestion is you don’t use table, but query but without using field timestamp
Don’t USe SELECT * FROM TABLE , but SELECT FieldA,FieldB,FieldC,… FROM TABLE