2005-04-03, 05:51 AM
The only trick to using dates with ADO.NET is making sure you've truncated off any seconds:
// set start date
saveScheduledRecordingCommand.Parameters[7].Value = new DateTime(scheduledRecording.getStartTime().Year, scheduledRecording.getStartTime().Month, scheduledRecording.getStartTime().Day, scheduledRecording.getStartTime().Hour, scheduledRecording.getStartTime().Minute, scheduledRecording.getStartTime().Second); saveScheduledRecordingCommand.Parameters[7].DbType = System.Data.DbType.DateTime;
// set start date
saveScheduledRecordingCommand.Parameters[7].Value = new DateTime(scheduledRecording.getStartTime().Year, scheduledRecording.getStartTime().Month, scheduledRecording.getStartTime().Day, scheduledRecording.getStartTime().Hour, scheduledRecording.getStartTime().Minute, scheduledRecording.getStartTime().Second); saveScheduledRecordingCommand.Parameters[7].DbType = System.Data.DbType.DateTime;