StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>For this purpose you have set a primary key id first in your table, which you are fetching as a source of the Grid.</p> <p>After binding the grid you should save that id in a hidden field. see the code below:</p> <pre><code> <asp:GridView ID="gvwID" runat="server" AutoGenerateColumns="False" DataKeyNames="TableID"> <Columns> <asp:TemplateField> <asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("TableID") %>'/> <asp:TemplateField> </Columns> </asp:GridView> </code></pre> <p>Then in the delete button click event get the selected row ids:</p> <pre><code> protected void Btn_Click(object sender, EventArgs e) { int[] OrderIDList = new int[gvwID.Rows.Count]; int index = 0; for (int count = 0; count < gvwID.Rows.Count; count++) { if (gvwID.Rows[count].FindControl("chkSelect") != null) { if (((CheckBox)gvwID.Rows[count].FindControl("chkSelect")).Checked) { if (gvwID.Rows[count].FindControl("HiddenField1") != null) { string OrderID = ((HiddenField)gvwID.Rows[count].FindControl("HiddenField1")).Value; OrderIDList[index++] = Convret.ToInt32(OrderID); } } } } </code></pre> <p>Then create an appended string from OrderIDList and pass it to the stored procedure. from the stored procedure create an xml using the appended string. Loop through the xml and get each id and perform the deletion.</p> <p>see the procedure below:</p> <pre><code> @IDList varchar(MAX) DECLARE @xmlUserIDs xml SELECT @xmlUserIDs = CONVERT(xml,'<root><cat>' + REPLACE(@IDList,',','</cat><cat>') + '</cat></root>')// creates xml from appended string DELETE FROM [TableName] WHERE [TableID] IN (SELECT [Value] = T.C.value('.','int') FROM @xmlUserIDs.nodes('/root/cat') T(C)); </code></pre> <p>Hope this helps you.. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload