Public void TimeExample(TdCommand cmd, String model)
{
cmd.Parameters.Clear();
cmd.CommandText = "SELECT StartDate, LeaseLen FROM AutoLeases " +
"WHERE Model = ?";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(null, TdType.VarChar, 10,
ParameterDirection.Input, true, 0, 0, null,
DataRowVersion.Default, model);
Int32 row = 0;
TdDate [] startDate;
TdIntervalYearToMonth [] leaseLen;
using (TdDataReader dr = cmd.ExecuteReader())
{
startDate = new TdDate[dr.RecordsReturned];
leaseLen = new TdIntervalYear [dr.RecordsReturned];
// Specifying an interval of 2 years with a precision of 2
TdIntervalYear twoExtraYears = new TdIntervalYear(2, 2);
while (dr.Read())
{
// Retrieving the dates
startDate[row] = dr.GetTdDate(0);
leaseLen[row] = dr.GetTdIntervalYear(1);
// Adding 2 years to the StartDate
startDate[row] = startDate[row] + twoExtraYears;
// Adding 2 years to the lease length;
leaseLen[row] = leaseLen[row] + twoExtraYears;
row++;
}
}
cmd.Parameters.Clear();
cmd.CommandText = "UPDATE AutoLeases " +
"SET StartDate = ?, LeaseLen = ? " +
"WHERE Model = ?";
cmd.Parameters.Add(null, TdType.Date, 0,
ParameterDirection.Input, true, 0, 0, null,
DataRowVersion.Default, null);
cmd.Parameters.Add(null, TdType.IntervalYear, 0,
ParameterDirection.Input, true, 0, 0, null,
DataRowVersion.Default, null);
cmd.Parameters.Add(null, TdType.VarChar, 9,
ParameterDirection.Input, true, 0, 0, null,
DataRowVersion.Default, model);
row--;
while(row >= 0)
{
cmd.Parameters[0].Value = startDate[row];
cmd.Parameters[1].Value = leaseLen[row];
cmd.ExecuteNonQuery();
row--;
}
}