For Each dr As DataRow In DataTables("会员信息").DataRows Dim dt As Date = dr("出生日期") dt = new Date(Date.Today.Year,dt.Month,dt.day) If dt >= Date.Today AndAlso dt <= dt.Today.AddDays(5) Dim dr2 As DataRow = DataTables("礼物").AddNew() dr2("会员ID") = dr("会员卡号") End If Next