IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator()
{
SqlDataRecord sdr = new SqlDataRecord(
new SqlMetaData("KeyField", SqlDbType.SmallInt),
new SqlMetaData("description", SqlDbType.VarChar, 30),
new SqlMetaData("MaxStudents", SqlDbType.Int),
new SqlMetaData("DeletedYN", SqlDbType.Bit),
new SqlMetaData("UpdateYN", SqlDbType.Bit),
new SqlMetaData("OKToDelete", SqlDbType.Bit));
foreach (Room i in this)
{
sdr.SetSqlInt16(0, i.KeyField);
sdr.SetString(1, i.description);
sdr.SetSqlNullableInt32(2, i.MaxStudents);
sdr.SetBoolean(3, i.DeleteYN);
sdr.SetBoolean(4, i.UpdateYN);
sdr.SetBoolean(5, i.OKToDelete);
yield return(sdr);
}
}
