how to do edit,update,delete functionality in jquery plugin

ramya t

hi ankit,

i have been shown the database values to datatable by using jquery datatable plugin,

refered by follwing as your post,

https://www.c-sharpcorner.com/article/display-data-in-Asp-Net-using-jquery-datatables-plugin/

now i want to edit the values bind according to the particular controls as well as update the values using web service and delete also,

please help me to resolve it,

3 Replies

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

Raghavendar Swaminathan8y ago
Hi Ramya,

500 Server Implies the issue is due to the server side code error (Suspect). Debug the code in Chrome, use breakpoints as well.

In Addition to that add this below code in the ajax call.

$.ajax({
/*options*/
}).always(function((data)){
if((data).statusCode === 200 || (data).stausCode === 500){
/*your logics*/
success: function (response) {
var msg = eval('(' + response.d + ')');
}
});

please check & let me know further assistance if needed.
0
ramya t8y ago
hi Raghavendar Swaminathan,

by using the second link ,i have an 500 internal server error,

i have put my code on below,
function bindRecordToEdit(id) {
$.ajax({
type: "POST",
url: location.pathname+"WebService/View_Event_type.asmx/bindRecordToEdit",
data: "{id:'" + id + "'}",
contentType: "application/json; charset=utf-8",
datatype: "jsondata",
async: "true",
success: function (response) {
var msg = eval('(' + response.d + ')');
$("#txtEvent_name").val(msg.cEvent_Name);
$("#txtdesc").val(msg.cDesc);
//=== store id of the selected record in hidden field so that we can use it later during
//=== update process.
$("#hfSelectedRecord").val(id);
//=== Hide save button and show update button.
//$("#btnSave").hide();
//$("#btnUpdate").css("display", "block");
},
error: function (response) {
alert(response.status + ' ' + response.statusText);
}
});
}
C#
[System.Web.Services.WebMethod(EnableSession = true)]
public static string bindRecordToEdit(int id)
{
string data = string.Empty;
try
{
string query = "select * from tbl_event_type where iID='"+id+"'";
SqlCommand cmd = new SqlCommand(query);
string constr = ConfigurationManager.ConnectionStrings["SafeStepDbContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
JavaScriptSerializer serializer = new JavaScriptSerializer();
data = serializer.Serialize(ds);
}
return data;
}
}
}
catch
{
return data;
}
}
i am using jquery datatable plugin for binding database values,when i click edit button ,the row value of table should be bind on textboxes..please help me to resolve it.
0
Raghavendar Swaminathan8y ago
Hi Ramya,

I assuming we need to perform the CRUD Operation in Jquery. If that is the case please find the below link for your reference.

Related Links
https://www.aspsnippets.com/Articles/ASPNet-jQuery-AJAX-CRUD-Select-Insert-Edit-Update-and-Delete-in-ASPNet-GridView-using-jQuery-AJAX.aspx

http://www.codingfusion.com/Post/Jquery-JSON-Add-Edit-Update-Delete-in-Asp-Net
Thanks
Raghav
+1