asp and ms sql.

I am working on asp and ms sql.

I have created a table called as 'usertable' in ms sql database.
The columns in 'usertable' are username, loginid, password.
The record gets added to this table, when a new user makes a fresh registration.

Eg: username = 'david'
loginid='daveuser'
password='newpass'

So My question is whenever a new user is added to a table, an automatic mail
should come to me '[email protected]' mentioning that a new user is added to table ALONG WITH HIS USERNAME, LOGINID, PASSWORD.
All this information should come to my email account automatically.
So how to write ASP Code for this.

Waiting for your reply.
Regards.

 

We have sample code on how to use CDO to send email from the web server. You can review it at http://kb.discountasp.net/article.aspx?id=10078. Insert this code after you execute your SQL query. Configure the TextBody of the email to contain all the details of the newly created login.

DiscountASP.NET
www.DiscountASP.NET