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

Yea i was thought thats how it should look, but im new to this and am
unsure how to get the id automatically into the url in the email.

Could you use my code then give me an example of what it should look
like.

Where abouts would i put the Request.QueryString["id"] ?

We have looked at the ID, and went with sequential as this link is not
given to any employees, only the IT Co-Ordinator.

We have named the id 'EITReqCode', which is in a table called
'IT_Request'.

Many thanks


bruce barker (sqlwork.com) wrote:

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