Hi, im trying to make a form for a page im building. But as someone who doesent normally make webpages with .net (i live in windows forms land) im in a bit of a muddle.
what i need to do is have a user fil the form in, the form then posts their info to SQL server (already got this working) Then on the "thankyou" page i need to have the page pull that same data back with the Unique ID from SQL (so im guessing post back) Then using the data from SQL send the data as XML to a 3rd party site and wait for the response.
if "ok" then - end, otherwise tell the user to try again etc.
Im struggling with the SQL bit (i figured stored procedure was the way to go), and im not sure if im going about all this in the right way. Ive used a query to pull data out as XML on my SQL server, but it pulls loads of records back not one - if i try use an @UniqueID it errors. Also the SQL generated is all on one line and needs line breaks and stuff, so im guessi ...
Go to the complete details ...