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

Question

Manas Mohapatra · Answer

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.

Deepak Awashti · Answer

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 ..

Manas Mohapatra · Answer

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 ; }

Deepak Awashti · Answer

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 $("#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(); } } }

Manas Mohapatra · Answer

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

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

Answers (5)