Re: automating email with links to records just submitted to an SQL DB using asp.net (vb)

the typical approach is to use a querystring in the url of the linek

http://mysite.com/orders/vieworder.aspx?id=<orderid>

then in the code behind you check the Request.QueryString["id"] for the
value passed. try not to make the id sequential, or they are easy to hack
(add one to your number and see someone else order)

-- bruce (sqlwork.com)


"Jimbo" <jimbo.oneill@xxxxxxxxx> wrote in message
news:1151417967.276078.93090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello

I am currently designing an internal ordering system for IT equipment.

I am designing it in ASP.NET (vb) using Visual Studio 2003 and using
Microsoft SQL Server

I have got the system to add the order into the database and assign it
a unique ID ("EITReqCode"), and made it e-mail the it purchaser via
SMTP automatically with a link to the "Authorisation" page where they
are to cost and authorise the IT request. What i want to be able to do
now, is add to that link the unique ID of the order just submitted so
when the purchaser opens the e-mail they will see the order which was
submitted relating to that specific email.

I am quite new to this and quite impressed with what i have achieved
single-handidly but now require some assistance.

Can anyone help me and advise me how to perform this function.

If you want to see some of my scripting already i will post it up.

Many thanks in advance.

James O'Neill
BSc (Hons) Business Information Systems Management



.

Relevant Pages
Loading