How to edit a record using Jquery Ajax??

rahul patil

6y868.NET

I want to edit a record but the record was not updated.

sp:

updatestud

ALTER PROCEDURE [dbo].[updatestud]

@studid int,

@studname varchar(50),

@studaddress varchar(50)

BEGIN

update tblstud set studname=@studname,studaddress=@studaddress where studid=@studid;

END

Webform1.aspx.cs

public static void EditData(int studid, string studname, string studaddress)
{
cn.Open();
SqlCommand cmd = new SqlCommand("updatestud", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studid", studid);
cmd.Parameters.AddWithValue("@studname", studname);
cmd.Parameters.AddWithValue("@studaddress", studaddress);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Console.WriteLine("Update Successfully");
}
else
{
Console.WriteLine("Not Update Successfully");
}
cn.Close();
}

Webform1.aspx

//for getdatalist
function GetData() {
$.ajax({
url: 'WebForm1.aspx/GetData',
type: 'post',
contentType: 'application/json;charset=utf-8',
datatype: 'json',
data: "{}",
success: function (data) {
data = JSON.parse(data.d);
for (var i = 0; i < data.length; i++) {
$("#tbl").append('' + data[i].studname + ' ' + data[i].studaddress + ' + data[i].studid + ', \'' + data[i].studname + '\' ,\'' + data[i].studaddress + '\')" /> ')
}
},
error: function () {
alert('Not Get Data')
},
});
}
//when I click on edit button then record going to form and then some changes in record and then press update then give an error Uncaught ReferenceError: studid is not defined?
function Update(studid, studname, studaddress) {
$.ajax({
url: 'WebForm1.aspx/EditData',
type: 'post',
contentType: 'application/json;charset=utf-8',
datatype: 'json',
data: "{studid: '" + studid + "',studname:'" + $("#txtname").val() + "',studaddress:'" + $("#txtaddress").val() + "'}",
success: function (data) {
data = JSON.parse(data.d);
studid = studid;
$("#txtname").val(studname);
$("#txtaddress").val(studaddress);
if (studid != null) {
$("#btnupdate").val("Update");
}
studid = studid;
},
error: function () {
alert('Update Error');
},
});
}

//when I click on edit button then record going to form and then some changes in record and then press update then give an error Uncaught ReferenceError: studid is not defined?

when i press on update then record going to form but again click on update then give an error

Response {"d":null}

WebForm1.aspx:84 Uncaught ReferenceError: studid is not defined

how to solve this issue??

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramachandran M6y ago
HI Rahul,

Change as below

function Update(studid, studname, studaddress) {

var dataValue = { "studid": studid ,"studname": $("#txtname").val(), "studaddress": $("#txtaddress").val() };
                            $.ajax({

                                url: 'WebForm1.aspx/Edit',
                                type: 'POST',
                                contentType: 'application/json;charset=utf-8',
                                datatype: 'json',
                                data: dataValue ,
                                success: function (data) {

                                    data = JSON.parse(data.d);

                                    studid = studid;

                                    $("#txtname").val(studname);
                                    $("#txtaddress").val(studaddress);

                                    if (studid != null) {

                                        $("#btnupdate").val("Update");

                                    }

                                    studid = studid;
                                },
                                error: function () {
                                    alert('Update Error');
                                },

                            });
                        }

Change
Jignesh Kumar6y ago
Hey rahul, l do not see any changes you have done. Please check you line still i am able to see '" you need to change revese "' + +'"
rahul patil6y ago
I m making another sp for fill data should update but not update a record
ajax call
$.ajax({

                              url: 'WebForm1.aspx/Edit',
                              type: 'post',
                              contentType: 'application/json;charset=utf-8',
                              datatype: 'json',
                              data: "{studid: '" + studid  + "'}",
                              success: function (data) {
                                  data = JSON.parse(data.d);
                              },
                              error: function () {
                                  alert('Update Error');
                              },
                          });
webmethod call
[WebMethod]
public static string Edit(int studid,string studname,string studaddress)
{
     string _data = "";
     cn.Open();
     SqlCommand cmd = new SqlCommand("editsp", cn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@studid", studid);
     cmd.Parameters.AddWithValue("@studname", studname);
     cmd.Parameters.AddWithValue("@studaddress", studaddress);

     SqlDataAdapter da = new SqlDataAdapter(cmd);
     DataSet ds = new DataSet();
     da.Fill(ds);
     cn.Close();
     if (ds.Tables[0].Rows.Count > 0)
     {
         _data = JsonConvert.SerializeObject(ds.Tables[0]);
     }
     return _data;
}
sp

ALTER PROCEDURE [dbo].[editsp]
    @studid int,
    @studname varchar(50),
    @studaddress varchar(50)
as
begin

      select * from tblstud where studid=@studid or studname=@studname or studaddress=@studaddress;

end
how to solve this issue?
Jignesh Kumar6y ago
Hi,

please change this line as below,
{studid: "' + studid + '",studname:"' + $("#txtname").val() + '",studaddress:"' + $("#txtaddress").val() + '"}",
rahul patil6y ago
still not work browser log :Update(150, '' ,'')

see my change s
data: "{studid: " + studid + ",studname:'" + $("#txtname").val() + "',studaddress:'" + $("#txtaddress").val() + "'}",
Ramachandran M6y ago
Hi

Remove single quotes from studid and try again

data: "{studid: '" + studid + "',studname:'" + $("#txtname").val() + "',studaddress:'" + $("#txtaddress").val() + "'}",