MVC2 Update Entity Framework Database using JQuery JSON Object (Please Help me get this working)

Question

I'm new to updating Enity Framework objects using JQuery and JSON. I created the entity objet in a console app and the update function and it works. I tried tranfering over to my web app and I can't get it to update through my web app.

Controller Code

[HttpPost]
    public ActionResult Update(int rowID)
    {
        var keyValues = new KeyValuePair<string, object>[] {
        new KeyValuePair<string, object>("QUICKFIX_ID", rowID)
        };

        var key = new EntityKey("CSCEntities.tbl_Quickfix_Toolbar", keyValues);

        var quickfixtbl = (tbl_Quickfix_Toolbar)db.GetObjectByKey(key);
        int usrcount = (int)quickfixtbl.USECOUNT_NR;

        // update
        usrcount = usrcount + 1;

        // find the row to update using the ID
        tbl_Quickfix_Toolbar quickFix = (from x in db.tbl_Quickfix_Toolbar
                                         where x.QUICKFIX_ID == rowID
                                         select x).First();
        quickFix.USECOUNT_NR = usrcount;
        db.SaveChanges();

        return View();
    }

and here is the JQueryfunction that calls my controller:

//Updates the use count in the List


function Update() {
  $.ajax({
          url: "/csc/devapp1/Home/Update",
          type: 'POST',
          data: "rowID=" +id,
          contentType: "application/json;charset=utf-8",
          success: function (data) {
                   alert('Details Updated Successfully');
          },
          error: function () {
                   alert('Unable to Update for the Given ID');
          }
   });

Please let me know what I'm doing wrong, I been going at this for weeks and can't get it to work.

Selman Genç · Accepted Answer · 2014-01-07 04:12:53Z

2

change this line:

data: "rowID=" +id,

to this:

data: JSON.stringify({ rowID : id }),

And probably your URL is wrong:

change this:

url: "/csc/devapp1/Hom/Update/",

to this:

url: '/Home/Update',

And it should work

edited Jan 7, 2014 at 4:12

answered Jan 7, 2014 at 3:36

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ross Bush Over a year ago

You could send in a value to your js for url also. So Url would be something like var [email protected]("Update","controller",new {[email protected]}); js.doSomething({url=url});

JEuvin Over a year ago

I updated the questions URL. I noticed I misspelled the URL *Home controller. I'm using JQGrid and when I tried using @Url.Action("Update","Home") it broke my code. The JQGrid doesn't display anymore.

JEuvin Over a year ago

It should but I'm not getting any updates to the DB using the Entity Framework. This is why I'm trying to figure out what I'm doing wrong and how I can go about a different way to get this to work.

Collectives™ on Stack Overflow

MVC2 Update Entity Framework Database using JQuery JSON Object (Please Help me get this working)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related