tag:blogger.com,1999:blog-7085941.post-1124826441930677042005-08-23T12:44:00.000-07:002005-08-23T12:47:21.936-07:00System.Data.OleDb.OleDbType.DBDate = store date only in the database;<br />System.Data.OleDb.OleDbType.DBTime= store time only in the database;<br /><br />>>> The wrong one<br />System.Data.OleDb.OleDbType.DBTimeStamp= store date&time only in the database;<br /><br />>>> The right one<br />System.Data.OleDb.OleDbType.Date= store date&time only in the database;<br /><br />Example:<br /><br />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));Joehttp://www.blogger.com/profile/04618327687649458144noreply@blogger.com