I have an SQL Datasource setup to insert a record into the DB. At the end of the Insert statement is a select statement allowing me to pull back the ID of the record I just inserted.I need to output that ID to a querystring so that i can do a response.redirect to point the records information.
This is the kind of thing I need to do. I need to get the parameter value from the query and output it to the redirect.
Any help would be appreciated.
Kindest regards
Chris