Update database with ajax on button click

Question

0.00/5 (No votes)

See more:

I have an ajax function in a javascript which is to update database on button click; below is the ajax snippet. What is the mistake in this code?
I mean the database is not getting updated!!

C#

<script type="text/javascript">

            function sav() {

         
           var class_id5 = document.getElementById('ddlClass5');
           var class_id6 = document.getElementById('ddlClass6');
           var class_id7 = document.getElementById('ddlClass7');
           var subj_id = document.getElementById('ddlSubject');
           var mark5 = document.getElementById('txtMark5');
           var mark6 = document.getElementById('txtMark6');
           var mark7 = document.getElementById('txtMark7');
          
           $.ajax({
               type: "POST",
               url: "Student.aspx/SaveData",
               data: {"class_id5": class_id5, "subj_id": subj_id, "mark5": mark5, "class_id6": class_id6, "class_id7": class_id7,
                   "mark6":mark6,"mark7":mark7},
               contentType: "application/json; charset=utf-8",
               dataType: "json",
               success: alert("success")});



                 }





   </script>

Posted 6-Jun-13 1:56am

Member 7677029

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar Sultan · Answer 1 · 2013-06-06T02:45:00

Solution 1

Change your code to:

JavaScript

<script type="text/javascript">
 
            function sav() {
 
         
           var class_id5 = document.getElementById('ddlClass5').value;
           var class_id6 = document.getElementById('ddlClass6').value;
           var class_id7 = document.getElementById('ddlClass7').value;
           var subj_id = document.getElementById('ddlSubject').value;
           var mark5 = document.getElementById('txtMark5').value;
           var mark6 = document.getElementById('txtMark6').value;
           var mark7 = document.getElementById('txtMark7').value;
          
           $.ajax({
               type: "POST",
               url: "Student.aspx/SaveData",
               data: "{class_id5:'" + class_id5 + "',subj_id:'" + subj_id + "',mark5:'" + mark5 + "',class_id6:'" + class_id6 + "',class_id7:'" + class_id7 + "',mark6:'" + mark6 + "',mark7:'" + mark7 + "'}",
               contentType: "application/json; charset=utf-8",
               dataType: "json",
              success: function () {
                        alert('success.');
                    }
}); 
                 } 
   </script>

Posted 6-Jun-13 2:45am

Zafar Sultan

Updated 6-Jun-13 2:46am

v2

Comments

Ankur^\m/ 6-Jun-13 8:46am

It would have been better if you pointed out the change that you made.

Zafar Sultan 6-Jun-13 8:50am

Sometimes it is better to make them yourself. Explanation at times becomes confusing. If I would have said "You need to pass parameters wrapped in single quotes", It eventually would have ended in me writing the above thing. :)

Ankur^\m/ 6-Jun-13 10:58am

My point was - ALSO state what changes you have made along with the change.

Zafar Sultan 7-Jun-13 3:18am

Yes. I missed that. Thanks.

Ankur^\m/ 6-Jun-13 8:48am

And if I am right you have just added the other parameters. How does that solve the problem? How do you know what parameters are expected on the server?

Zafar Sultan 6-Jun-13 8:51am

Which other parameter?

Ankur^\m/ 6-Jun-13 10:59am

See. It's difficult to compare the code blocks and find out what changes you made. I meant you added more parameters to data.

Zafar Sultan 7-Jun-13 3:17am

I did not make any changes other than modifying the data format that was being passed neither did I add any extra parameter. The parameters name and numbers are exactly the same as used by the OP

Member 7677029 7-Jun-13 0:04am

But the updation is not happening still :(

Member 7677029 7-Jun-13 2:27am

data is not being passed from the ajax to the method SaveData() in .aspx.cs

Zafar Sultan 7-Jun-13 3:20am

How are you catching parameters in SaveData() method?