VB.NET - SQL Server
Posted on 2004-09-28
I have a few questions.
1. Does anyone know where I can find data type comparison chart between VB.NET and SQL Server data types.
2. I have a piece of code which uses a data reader to bring in a set a records, I loop through each record and assign it to a class then add the class to an array list. For each field I check it is not null, if it is not null I convert it to the relevant class property type.
The problem I have is this, when the field is a sql server timestamp or datetime can I use the System.Convert class to convert them or do I need something else?
The class properties are declared as follows
timestamp = object
datetime = date