updating database from checkbox using ajax

Question

im trying to update my database from the checkbox in a grid view. i want to do it using ajax so that the page doesn't have to refresh everytime i click o the checkbox. how am i supposed to do that?

Answer 1

You can use JavaScript with a little help from jQuery Library to post to an .aspx page. I wrote an example for PHP here http://stackoverflow.com/questions/1353678. The javascript part would stay the same, but on the server side you would have to read the query string to read in the variables using Request.querystring. Also If you want to return JSON data you will have to change the response type to be plain text rather HTML. Like this:

context.Response.ContentType = "text/plain";

Answer 2

use event onChange on your checkbox and make it call your ajax function..

eg with jquery:

<input type=checkbox onchange="javascript: doOnChange();">

<script>
function doOnChange() {

     $.ajax({
         type: "GET",
         url: "/url/to/your/controller.php",
         data: ...,
         dataType: "html",

         success: function(data){
                      ...;
                  },

         error: function(data){

                      ...;
                }
     });
};
</script>