Click here to Skip to main content
15,879,348 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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..........
Posted

1 solution

try this.. :)

Javascript
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({
              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();

}
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900