H
Hasani
I'm working with a database that has 100+ tables and the average table has
at least 40 columns.
using the OleDbParameter class, some tables use Timestamps, and other use
Dates, but when retrieved from the database, using a DataRow, they all show
up as System.DateTime objects. Now when I update these values and place them
in an OleDbParameter object, they are automatically determined to be
TimeStamps, but for some columns, they should be database Date types.
I figured, if any ADO.NET object were to know what the proper DbType should
be, it would be the DataColumn object, but I can't seem to find that
anywhere.
Am I forcred to manually specifiy the DbType for each column in my 100+
tables?
at least 40 columns.
using the OleDbParameter class, some tables use Timestamps, and other use
Dates, but when retrieved from the database, using a DataRow, they all show
up as System.DateTime objects. Now when I update these values and place them
in an OleDbParameter object, they are automatically determined to be
TimeStamps, but for some columns, they should be database Date types.
I figured, if any ADO.NET object were to know what the proper DbType should
be, it would be the DataColumn object, but I can't seem to find that
anywhere.
Am I forcred to manually specifiy the DbType for each column in my 100+
tables?