Super Urgent Codes To Compare Datafield Date With Today's Date

Hi, I really need this help urgently.

I need to send an email when the dueDate(field name in database) is equal to today's date... I have come out with this code with the help of impathan(jimmy i did not use ur code cos i not very sure sry)... below is the code with no error... but it jus wun send email...

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load

con1.Open()

Dim cmd As New SqlCommand

cmd.CommandText = "select * from custTransaction where convert(datetime,dueDate,101) = convert(datetime,GetDate(),101)"

'Set the connect the command object should use

cmd.Connection = con1Dim da As New SqlDataAdapter(cmd)Dim ds As New DataSet

da.Fill(ds)

con1.Close()

If Not ds.Tables(0) Is Nothing ThenIf ds.Tables(0).Rows.Count > 0 Then

 Dim objEmail As MailMessage = New MailMessage

objEmail.From = New MailAddress("my@email.com.sg")objEmail.To.Add(New MailAddress("my@email.com.sg"))

objEmail.Subject = "Due Date Reaching"objEmail.Body = Session("dueName")

objEmail.Priority = MailPriority.Normal

Dim SmtpMail As New SmtpClient("servername")

SmtpMail.Send(objEmail)

End If

End If

End Sub

Note: I am veri sure that database has the data field dueDate with the value 11/16/2007 smalltimedate(mm/dd/yyyy)

Realli veri urgent Thanks so much for ur'll help