如何通过使用Jquery和Ajax基于用户选定的复选框删除转发器中的行？ [英] How Do I Delete A Row In A Repeater By Basing On The User Selected Checkbox Using Jquery And Ajax ?

问题描述

如何根据用户选中的复选框删除asp.net转发器中的行。只需单击重新加载按钮即可显示剩余的行。

这可能需要使用jQuery和Ajax完成？

请尽快回复我需要快速回复..........

How do I delete a row in a asp.net repeater by basing on the user selected checkbox .And remaining rows need to appear with out clicking on the reload button.
And this can need to be done using jQuery and Ajax ??
Please reply as soon as possible I need quick replys please..........

推荐答案

试试这个.. :)



Javascript

try this.. :)

Javascript

function GetChecked() {
          var container = document.getElementById("RepeaterID");
          var totalInputs = container.getElementsByTagName('input');
          var id = "";

          for (var i = 0; i < totalInputs.Length; i++) {
              if (totalInputs[i].type.toLowerCase() == 'checkbox' && totalInputs[i].checked) {
               id += totalInputs[i].id+",";

              }
          }
          DeleteData(id);
      }


      function DeleteData(id) {

.ajax （{
类型： POST，
url： Default.aspx / DeleteData， // pagename.aspx / methodName
contentType： application / json; charset = utf-8，
data： {'id'：' + id + '}，
dataType： json，
成功：功能 （数据）{

alert（ 数据删除成功）;

}，
错误：功能（结果）{

alert（ 错误）;
}

}）;

}

.ajax({ type: "POST", url: "Default.aspx/DeleteData", //pagename.aspx/methodName contentType: "application/json;charset=utf-8", data: "{'id':'" + id + "'}", dataType: "json", success: function (data) { alert("Data deleted successfully"); }, error: function (result) { alert("Error"); } }); }

HTML

HTML

<span  önclick="GetChecked()">Delete Selected Data</span>

<![CDATA[<%--Repeater Design with checkbox--%>

c＃

c#

[WebMethod]
public static void DeleteData(string id)
{

    string DeleteStr = "delete from Tablename where id in("+id+")";

    SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionstringName"].ConnectionString);
    SqlCommand sql_cmd = new SqlCommand(DeleteStr, cn);
    cn.Open();
    sql_cmd.ExecuteNonQuery();

    cn.Close();
    cn.Dispose();
    sql_cmd.Dispose();

}

这篇关于如何通过使用Jquery和Ajax基于用户选定的复选框删除转发器中的行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！