Experience in C++, C#, Java and Process : Living in Montreal

* What is my technical experience as a software developer

* What I have learned in the software business

* Where I am heading to in my career

* How to process in a project

Tuesday, August 23, 2005

DBDate, DBTime, DBTimeStamp, Date

System.Data.OleDb.OleDbType.DBDate = store date only in the database;
System.Data.OleDb.OleDbType.DBTime= store time only in the database;

>>> The wrong one
System.Data.OleDb.OleDbType.DBTimeStamp= store date&time only in the database;

>>> The right one
System.Data.OleDb.OleDbType.Date= store date&time only in the database;

Example:

this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_TradeTime", System.Data.OleDb.OleDbType.Date, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TradeTime", System.Data.DataRowVersion.Original, null));