I have a SqlDataSource set up on my page with an insert command that inserts the values from a form on the same page. To execute it I use SqlDataSource.Insert() in the code behind of the submit button. That part works just fine.
I also need it to e-mail the information from the form on submit - I also have that working just fine.
What I haven't been able to figure out though is how to return the identity of the inserted information so that I can use it as a line in the body of the e-mail.
I've done lots of searching and reading and understand how I can use Scope_Identity() with a SQLCommand but I'm not defining one since I'm using a SqlDataSource control instead.
I'm still kind of new to VS 2005 and C# so maybe I'm just going about this all wrong... Any help would be appreciated.
Deleted by modus_operandi, 500 points refunded. - 8/25/2007 9:18:39 PM