单击按钮时，从gridview plus中从数据库中删除选定的行. [英] remove selected row from gridview plus from the database on button click.

问题描述

大家好，
我的问题是我有一个网格视图，用于显示绑定到数据表的内部消息的收件箱内容.当我借助复选框检查特定行时，应从网格视图中删除该行，再从位于Gridview外部的DELETE Button Command上的数据库中删除该行.如何从网格视图中删除特定行和所有选定的行. > 感谢您的问候，
Naveen

Hello All,
My problem is that I have a grid view for displaying inbox content of internal messages which is binded to a datatable. When I check a particular row with the help of check box ,that row should removed from grid view plus from the database on DELETE Button Command located outside the Gridview .How to remove the particular row and all selected rows from grid view.
Thanks with Regards,
Naveen

推荐答案

在删除"按钮中单击事件

In delete button click event

foreach (GridViewRow gvrow in GridView1.Rows)
{
 //use findcontrol to get the check box.
 if(checkbox.checked)
 {
   // code to delete the checked rows from database.
 }
}

尝试.

Try..

这是一个示例
试试这个

编写Javascript函数以这种方式存储Productid(1 | 2 | 3 | 4)

this is an example
try this

write Javascript function To store Productid (1|2|3|4) in this way

function Fn_JsOrders_GetCheckBoxList() {
            var jsVar_Orders_OrderId = "";
            var flag = false;

            // alert(document.aspnetForm.OrderId.length);
            var ctrls = document.getElementsByTagName("input");
            for (var i = 1; i < ctrls.length; i++) {
                if (ctrls[i].checked == true) {
                    //  alert(jsVar_Orders_OrderId);
                    jsVar_Orders_OrderId = jsVar_Orders_OrderId + ctrls[i].value + "|";
                }
            }
            if (jsVar_Orders_OrderId.length == 0) {
                alert("Please Select Atleast One item");
                flag = false;
            }
            else {
                document.getElementById("<%=hid.ClientID %>").value = jsVar_Orders_OrderId;
                var answer1 = confirm("Are You Sure You Want to Delete ?");
                if (answer1) {
                    flag = true;
                    document.aspnetForm.submit();
                }
                else {
                    flag = false;
                }
            }
            return flag;

        }

hid_Hospital_HospitalId.ClientID(Hiddenfield)在您的aspx页面中声明hiddent字段


在代码behid中


点击删除按钮

hid_Hospital_HospitalId.ClientID (Hiddenfield) declare hiddent field in ur aspx page


In code behid


on click on delete button

Id = (HiddenFieldvalue)

char[] separator = new char[] { ''|'' };
                string[] strProductId = ProductId.Split(separator);
                string[] strProductQuantity = ProductQuantity.Split(separator);
                for (int i = 0; i < strProductId.Length - 1; i++)
                {
                    int ProdId = Convert.ToInt32(strProductId[i]);

                    

                    Result = fn_Delete(ProdId);

                }

这篇关于单击按钮时，从gridview plus中从数据库中删除选定的行.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！