Updating database on button click from email body

Question

hi Developers  I am sending an email from my Application (C#.net). Body of email have 2 buttons approve and Reject ..I want to know whether i can update database on clicking approve or reject button without opening any link to my application. i get confused so suggest me to i am done this task

Jitendra Shekhawat · Answer

You can try with simple ajax calls like below: Consider this is the html on your email: charset = utf-8 /> src = Scripts/jquery-1.10.2.js > type = text/javascript > // Ajax call using jquery to your website's page function callAjax ( actiontype ) { var request = $ . ajax ({ url : http://yoururl/webform1.aspx  method : GET  data : { paramvalue : actiontype } dataType : html }); } type = button onclick =  callAjax ( 'Accept' );  value = Accept /> type = button onclick =  callAjax ( 'Reject' );  value = Reject /> Below is the Webform1.aspx code behind where you can catch the parameter based on button click and do update on the DB. public partial class WebForm1 : System . Web . UI . Page { protected void Page_Load ( object sender  EventArgs e ) { var action = Request . QueryString [ paramvalue ]; if (! string . IsNullOrEmpty ( action )) { // implement the rest of the stuff if ( action . ToLower () == accept ) { // update DB } else if ( action == reject ) { // Update DB } } } } Hope this helps!

Paul Rajs · Answer

@Jitendra Shekhawat i have to send this html page to Mail.then if i click the Accept or reject button na i will come to my page and update my database table as my want. am i Correct ...? Paul.S