I m performing crud operation using ajax jquery. I m inserting data in the database but I want to get the data and that data update and delete run time but my getdata method does not work??
Emploee.aspx.cs
- [WebMethod] //insert
- public static void insertdata(string name, int age, string address)
- {
- cn.Open();
- SqlCommand cmd = new SqlCommand("sp_tblEmployee_Insert", cn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@EmpName", name);
- cmd.Parameters.AddWithValue("@EmpAge", age);
- cmd.Parameters.AddWithValue("@EmpAddress", address);
- cmd.ExecuteNonQuery();
- cn.Close();
- }
- [WebMethod]
- public static string GetEmpData()
- {
- cn.Open();
- string data = "";
- SqlCommand cmd = new SqlCommand("sp_tblEmployee_Select", cn);
- cmd.CommandType = CommandType.StoredProcedure;
- 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]);//read and write the jsontext
- }
- return data;
- }
Emploee.aspx
- $(document).ready(function () {
- getdata();
- });
- //insert
- function SaveData()
- {
- if ($("#btnsubmit").val() == "Submit")
- {
- $.ajax({
- url: 'Emploee.aspx/insertdata',
- type: 'post',
- contentType: 'application/json;charset=utf-8',
- dataType: 'json',
- data: "{name:'" + $("#txtName").val() + "',age:'" + $("#txtAge").val() + "',address:'" + $("#txtAddress").val() + "'}",
- success: function () {
- alert("Insert Data Successfully");
- getdata();
- },
- Error: function () {
- alert("Insert Error");
- }
- });
- }
- else
- {
- $.ajax({
- url: 'Emploee.aspx/Update',
- type: 'post',
- contentType: 'application/json;charset=utf-8',
- dataType: 'json',
- data: "{Id:'" + id + "',name:'" + $("#txtName").val + "',age:'" + $("#txtAge").val + "',address:'" + $("#txtAddress").val + "'}",
- success: function () {
- alert("Update data Successfully");
- getdata();
- },
- error: function () {
- alert("Update Error");
- }
- });
- }
- }
- //getdata
- function getdata() //i think this function is not work
- {
- $.ajax({
- url: 'Emloyee.aspx/GetEmpData',
- type: 'get',
- contentType: 'application/json;charset=utf-8',
- dataType: 'json',
- data: "{}",
- success: function (data) {
- data = JSON.parse(data.d);
- $("#tbl").find("tr:gt(0)").remove();
- for (var i = 0; i < data.length; i++) {
- $("#tbl").append('
' + data[i].EmpName + ' ' + data[i].EmpAge + ' ' + data[i].EmpAddress + ' - }
- },
- Error: function () {
- alert("get error");
- }
- });
- }
Jquery Crud Index Update Delete Name: Age: Address: Enmployee Name Employee Age Employee Address