ASP.NET C# Need to email record after inserting into SQL

[Christopher Hayes]

Using DMX 2004, WinXP Pro, MS SQL Server 2000, ASP.NET C#.

I am using a standard Insert Record behavior and after the record is
successfully inserted into the database, I need it to be emailed using
ASPNET Mail.

Can someone please help me with this. I'm at a loss.

Thanks,

Chris Hayes

[RajDogLives]

I'm not sure on the details cause I've done things like this using asp, all you
need to do is get the record ID after insert. It's more of a SQL server issue
than anything else. I would search for info on identity or scope identity.
Here is some code I used in SQL server and ASP:
InsertCommand.Execute(InsertCommand) Set rsNewID =
InsertCommand.Execute('SELECT SCOPE_IDENTITY()') Session ('varID') =
rsNewID(0) rsNewID.Close Set rsNewID = Nothing