how to update data using Jquery in asp.net c# Code

Deepak Awashti

10y1.3k.NET

5 Replies

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

Manas Mohapatra10y ago
Did you follow my previous answer properly. Because if you miss some part then it won't work perfectly.

Secondly put a break point in your method and see if it hits your break point.

Thirdly in error function to get more info. Search in google how to get error in jquery Ajax and use it.
0
Deepak Awashti10y ago
Sir , you are very helpfull and i impliment your code in my wed application but it is not work in proper all tym run in Else part and show alert box ( Data not found..)
why sir ..
0
Manas Mohapatra10y ago
Go through below steps:

Step 1: In ASPX page(change in Javascript code):

// code for Search Button with E_id ……..
$(function () {
   $("#btnSearch").click(function () {
      var E_id = $("#txtE_id").val();
      if (E_id != null) {
      $.ajax({
         type: "POST",
         contentType: "application/json; charset=utf-8",
         url: "Default.aspx/SearchData",
         data: "{'E_id':" + E_id + "}",
         dataType: "json",
         success: function (data)
         {
            if (data.d.length > 0) {
               alert("hello");
               if (data.d != '') {
                  $("#txtname").val(data.d.Name);
                  $("#txtage").val(data.d.Age);
                  $("#txtaddress").val(data.d.Address);
                  $("#txtemail").val(data.d.Email_id);
                  $("#txtpswd").val(data.d.Pswd);
            }
         }
      alert("Data found");
      },
      error: function (data)
      {
         alert('Data not found');
      }
   });
}
else
{
   return false;
}
});
});

Step 2: Change in code behind file(Add a class)

public class Employee {
   public string Name {get; set;};
public string Age {get; set;};
   public string Address {get; set;};
   public string Email_id {get; set;};
   public string Pswd {get; set;};
}

Step 3: Change in code behind (to return object)

[WebMethod]
public static Employee SearchData(int E_id)
{
   Employee objEmployee = new Employee();
   SqlDataReader dr;
   SqlConnection con = new SqlConnection(@"Data Source=TWINKLE-PC;Initial    Catalog=Degital Dreams;Integrated Security=True");
   {
      using (SqlCommand cmd = new SqlCommand("select Name,Age,Address,Email_id,Pswd from Registration where E_id=@E_id", con))
   {
   cmd.CommandType = CommandType.Text;
   cmd.Parameters.AddWithValue("@E_id", E_id);
   con.Open();
   dr = cmd.ExecuteReader();

   if (dr.Read())
   {
      objEmployee.Name = dr["Name"].ToString();
      objEmployee.Age = int.Parse(dr["Age"].ToString());
      objEmployee.Address = dr["Address"].ToString();
      objEmployee.Email_id = dr["Email_id"].ToString();
      objEmployee.Pswd = dr["Pswd"].ToString();
   }

   con.Close();
   }
}

return objEmployee;
}
0
Deepak Awashti10y ago
i implement in this code but it is not working in proper way

// code for Search Button with E_id ……..
$(function () {
$("#btnSearch").click(function () {
var E_id = $("#txtE_id").val();
if (E_id != null) {

$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/SearchData",
//data: "{Name: ' " + Name + " ',Age:'" + Age + "',Address:'" + Address + "',Email_id:'" + Email_id + "',Pswd:'" + Pswd + "'}",
data: "{'E_id':" + E_id + "}",
dataType: "json",
success: function (data)
{
if (data.d.length > 0) {
alert("hello");
for (var i = 0; i < data.d.length; i++) {
$("#txtname").val(data.d[i].Name);
$("#txtage").val(data.d[i].Age);
$("#txtaddress").val(data.d[i].Address);
$("#txtemail").val(data.d[i].Email_id);
$("#txtpswd").val(data.d[i].Pswd);
}
}
alert("Data found");
},
error: function (data)
{
alert('Data not found');
}
});
}
else
{
return false;
}
});
});

--------------------------------.CS page Code....-----------------------------

public static void SearchData(int E_id)
{
SqlDataReader dr;
SqlConnection con = new SqlConnection(@"Data Source=TWINKLE-PC;Initial Catalog=Degital Dreams;Integrated Security=True");
{
using (SqlCommand cmd = new SqlCommand("select Name,Age,Address,Email_id,Pswd from Registration where E_id=@E_id", con))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@E_id", E_id);
con.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
//Name = dr["Name"].ToString();
//Age = int.Parse(dr["Age"].ToString());
//Address = dr["Address"].ToString();
//Email_id = dr["Email_id"].ToString();
//Pswd = dr["Pswd"].ToString();
}
con.Close();

}
}

}

0
Manas Mohapatra10y ago
What is your requirement define properly. If you say your requirement in one short line how can a author understand it. Please elaborate more..
0