-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BanupriyaVelmurugan
Message 1 in Discussion
Hi I have created a sqldataadapter, sqlconnection, and dataset named dsBirthday1 in
my asp.net project and added the following code in the page_load subroutine Private
Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
'Put user code to initialize the page here
Dim FFrom, TTo, SSubject, BBody As String
If Not IsPostBack Then
SqlDataAdapter1.Fill(DsBirthday1)
If IsNothing(DsBirthday1) Then
Response.Write("Hi")
Exit Sub
Else
FFrom = "asdf"
Dim dsMyRow As DataRow = DsBirthday1.Birthday(0)
TTo = dsMyRow("Email")
SSubject = "Whish you a happy and Prosperous Birthday! :-)"
BBody = "Hello " & dsMyRow("Name") & ", <br> Many more happy returns of the day! <br>
Long Live! <br> By <br> Banupriya."
Try
SmtpMail.Send(FFrom, TTo, SSubject, BBody)
Response.Write("Birthday card is sent sucessfully")
Catch ex As Exception
Response.Write("Sorry! Error in sending the birthday mail!")
End Try
End If
End If
End Sub
The message "Birthday card is sent sucessfully" is displaying on execution. But I am
not receiving any mail from the project. Also it doen't raise any error when the
database contains the data for the query
select * from Birthday where day(DOB)=day(getdate()) and month(DOB)=month(getdate())
2. Also please say me how to find the eof or bof condition for the dataset.
thanx for ur reply
regards
Banupriya
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
