how to delete multiple item using checkbox in gridview control?

Question

hello i want to delete multiple item using checkbox in gridview control ..

here is my code:

 

 
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
AutoGenerateColumns="False"
BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
CellPadding="2" DataKeyNames="code" DataSourceID="SqlDataSource1"
OnRowCancelingEdit="GridView1_RowCancelingEdit" 
OnRowEditing="GridView1_RowEditing" 
OnRowUpdating="GridView1_RowUpdating" 
GridLines="Vertical"
OnRowDeleting="GridView1_RowDeleting" Width="200px">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<Columns>
<asp:TemplateField HeaderText="Item">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("purl", "items/{0}") %>' />
</ItemTemplate>
<ControlStyle Height="100px" Width="100px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Product Code" SortExpression="Product Code">
<ItemTemplate>
<asp:Label ID="lblcode" runat="server" Text='<%# Bind("code") %>'/>
</ItemTemplate>
<ControlStyle Width="20px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Product Name" SortExpression="Product Name">
<ItemTemplate>
<asp:Label ID="lblpname" runat="server" Text='<%# Bind("pname") %>'/>
</ItemTemplate>
<ControlStyle Width="120px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Price" SortExpression="Price">
<ItemTemplate>
<asp:Label ID="lblprice" runat="server" Text='<%# Bind("price") %>'/>
</ItemTemplate>
<ControlStyle Width="100px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Quantity" SortExpression="Quantity">
<EditItemTemplate>
<asp:TextBox ID="txtqty" runat="server" Text='<%# Bind("qty") %>'/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblqty" runat="server" Text='<%# Bind("qty") %>'/>
</ItemTemplate>
<ControlStyle Width="20px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Total" SortExpression="Total">
<ItemTemplate>
<asp:Label ID="lbltot" runat="server" Text='<%# Bind("tot") %>'/>
</ItemTemplate>
<ControlStyle Width="100px" />
</asp:TemplateField>
<asp:CommandField ButtonType="Button" ShowDeleteButton="True" ShowEditButton="True"
ShowSelectButton="True" HeaderText="Update" >
<ControlStyle Width="50px" />
<ItemStyle Width="20px" />
</asp:CommandField>
<asp:TemplateField HeaderText="check">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
<ControlStyle Width="10px" />
</asp:TemplateField>
</Columns>
<PagerStyle ForeColor="Black" HorizontalAlign="Center" BackColor="#999999" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="Gainsboro" />
</asp:GridView>
<br /><br /></center> 
<div align="right">
<asp:Label ForeColor="white" ID="lblt" Text="Total:" Font-Bold="True" Font-Size="X-Large" Width="108px" runat="server"/>
<asp:Label CssClass="lbl1" ForeColor="White" ID="lbltot" Text="" runat="server" Font-Bold="True" Font-Size="X-Large" Width="108px"/>
</div>
<br /><br /><br /><br />
<asp:Button ID="final" runat="server" Text="Final Purchase" OnClick="final_Click" /> 
<br />
<br />
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT purl,code,pname,price,qty,(qty*price)as tot FROM [tmp]"
UpdateCommand="UPDATE [tmp] set
[qty] =@qty 
WHERE [code] = @code" DeleteCommand="delete tmp where code='@code'">

<UpdateParameters>
<asp:Parameter Name="qty" Type="Int32" /> 
<asp:Parameter Name="code" Type="String" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="code" Type="string" />
</DeleteParameters>
</asp:SqlDataSource>

Kirtan Patel · Answer

Hi Corrected the Code now it works and Calculate total in any condition :) I Also Included Corrected Skin File that was showing Same Home Text on All buttons http://www.mediafire.com/?mjxndte52nd

Dipa Ahuja · Answer

Wow..!! Its done.. your too gr8.. thanx.. i marked your ans.. :))

Dipa Ahuja · Answer

it work well in every condition exept when u delete any item with the LAST item jz tell me the place where should i write the code to set total in lbltot after the items are deleted from cart

Dipa Ahuja · Answer

Error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index the error is coz of below the line ---->>: objConnection.Open(); SqlCommand commt = new SqlCommand ( select sum(total) as 'All total' from tmp  objConnection); ---->>>> double TotalofAll = Convert .ToDouble(commt.ExecuteScalar()); objConnection.Close(); lbltot.Text = TotalofAll.ToString(); it cause the error when u r trying to delete more than one items  WITH THE LAST ITEM( 1st n last 3rd n last or any middle item and last...) then it gives you the following error.. :(

Dipa Ahuja · Answer

Whare to put the label of total ?? it causing error when i delete any item with the last item... dowload this cart.aspx : http://www.mediafire.com/?lwcgdzk0oni

Dipa Ahuja · Answer

so u mean that index doesnt matters..? ok ok the main thing now my code is working well.. thank u!

Kirtan Patel · Answer

me 3 erase karna bhul gaya actually waha 1 hi ayega but still it finds the lblcode from row chreers :)

Dipa Ahuja · Answer

ohhh a biiiiig thank you to you kirtan.. thanx!! bt would you plz make me understand 2 things.. u have specified wt was problems? This my code protected void btnMultipleRowDelete_Click( object sender EventArgs e) { //Code From NET // Looping through all the rows in the GridView foreach ( GridViewRow row in GridView1.Rows) { System.Web.UI.WebControls. CheckBox checkbox = (System.Web.UI.WebControls. CheckBox )row.FindControl( cbRows ); string code; //Check if the checkbox is checked. if (checkbox.Checked){ // Retreive the CODE code = GridView1.DataKeys[row.RowIndex].Value.ToString(); MessageBox .Show( RowIndex Is: + row.RowIndex.ToString()); objConnection.Open(); SqlCommand comm = new SqlCommand ( DELETE tmp WHERE code=@code  objConnection); comm.Parameters.AddWithValue( @code  code.ToString()); comm.ExecuteNonQuery();objConnection.Close(); GridView1.DataBind(); } } } This your Code: protected void btnMultipleRowDelete_Click( object sender EventArgs e) { // Looping through all the rows in the GridView foreach ( GridViewRow r in GridView1.Rows) { if ((( CheckBox )r.Cells[0].FindControl( cbRows )).Checked == true ) { string code = (( Label )r.Cells[3].FindControl( lblCode )).Text; //Response.Write(code); objConnection.Open(); SqlCommand comm = new SqlCommand ( delete from tmp WHERE code=@code  objConnection); comm.Parameters.AddWithValue( @code  code); comm.ExecuteNonQuery(); objConnection.Close(); // Page.RegisterClientScriptBlock(  alert(' + code + ') ); } } GridView1.DataBind(); } 1st problem u said delete query was wrong.. means i 4get the from keyword.... rite? n second plz make me understand this line how it retrieves ..? n in this the cell of the prodct is at 2nd position so y u wrote cells[3] ? string code = (( Label )r.Cells[3].FindControl( lblCode )).Text; thanx... n ya i marked ur answer.. :)

Kirtan Patel · Answer

Hi Diya  Here i Corrected the code for Products/cart.aspx page the problem was 1. delete query was not correct 2. you have made code column Template column so we can't access it through r.cell[0].Text Directly 3 . You should Not User MessageBox.Show() method From Windows Form Class Because the messageBox will be Shown Only On Server Side Instead you should use JavaScript Message Box by Below Code :) Page.RegisterClientScriptBlock( alert('Testing Message Box') ); ------------------------------- Corrected Project Files

Dipa Ahuja · Answer

oh sorry!! here is the link of my website.. http://www.mediafire.com/file/mkwynvmyfmy/AJAXEnabledWebSite2.rar thanx...!!

Kirtan Patel · Answer

friend i m not telling that you are fool yaar . but commonly user can make mistake like that . even i also do this type of mistake sometime :) can you send me your code in mail i will resolve it quickly ..and let you know where you doin mistake :) just make zip file of your project and Upload it on http://www.mediafire.com and Give me the link to download it :) or you are online at Yahoo or Gmail Chat then Contact me there i will resove it using remote connection from my pc yahoo : exploite.world@yahoo.com Gmail : kirtan007@gmail.com

Dipa Ahuja · Answer

u think i am that much fool that i have juz copy paste your code..? even in my code the index is 1 of the field code bt then also its not working

Kirtan Patel · Answer

use like below code to retrievecode string code = r.Cells[ Index_Of_Primary_KeyColumn_In_GridView_Here ].Text; objConnection.Open(); SqlCommand comm = new SqlCommand ( DELETE from tmp WHERE code=@code  objConnection); comm.Parameters.AddWithValue( @code  code); don't use r.Cells[1] as I used 1 in my code because in GridView Username (Primary Key Column is there so ..) my code is working fine when selecting First and Last Row.my be you having problem because of you are using DataKey :) One more thing be low code is very important protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { ShowDataInGrid(); } }

Dipa Ahuja · Answer

n ya your code for all checkbox selection works.. thanx for that...!! :)

Dipa Ahuja · Answer

it work well in your example.. bt same code i used then its not working... whats the problem ? asp : TemplateField > EditItemTemplate > asp : CheckBox ID =cbRows runat =server /> EditItemTemplate > ItemTemplate > asp : CheckBox ID =cbRows runat =server /> ItemTemplate > asp : TemplateField > asp : TemplateField HeaderText =Product Code SortExpression =Product Code> ItemTemplate > asp : Label ID =lblcode runat =server Text =' '/> ItemTemplate > ControlStyle Width =20px /> asp : TemplateField > asp : Button ID =btnselect runat =server Text =Select All OnClick =btnselect_Click /> asp : Button ID =btnMultipleRowDelete OnClick =btnMultipleRowDelete_Click runat =server Text =Remove From Cart /> .cs file protected void btnMultipleRowDelete_Click( object sender EventArgs e) { foreach ( GridViewRow r in GridView1.Rows) { //find Which Check Boxes are checked !! if (((System.Web.UI.WebControls. CheckBox )r.Cells[0].FindControl( cbRows )).Checked == true ) { //Get the Username from column 1 and delete the row in database string code = r.Cells[1].Text; MessageBox .Show(code.ToString()); //Delete the row in database according to Usernamevalue objConnection.Open(); SqlCommand comm = new SqlCommand ( DELETE tmp WHERE code=@code  objConnection); comm.Parameters.AddWithValue( @code  code.ToString()); comm.ExecuteNonQuery(); objConnection.Close(); } } //Finally Show Updated Data in GridView GridView1.DataBind(); } in above the message box of code.toString() gives value nothin.. n therefore none of the item is deleted... i used another code as below: protected void btnMultipleRowDelete_Click( object sender EventArgs e) { foreach ( GridViewRow row in GridView1.Rows) { System.Web.UI.WebControls. CheckBox checkbox = (System.Web.UI.WebControls. CheckBox )row.FindControl( cbRows ); string code; //Check if the checkbox is checked. if (checkbox.Checked) { // Retreive the CODE code = GridView1.DataKeys[row.RowIndex].Value.ToString(); MessageBox .Show( RowIndex Is: + row.RowIndex.ToString()); objConnection.Open(); SqlCommand comm = new SqlCommand ( DELETE tmp WHERE code=@code  objConnection); comm.Parameters.AddWithValue( @code  code.ToString()); comm.ExecuteNonQuery(); objConnection.Close(); GridView1.DataBind(); } } } in this it work well bt only one problem occurr: when we delete single item(1st last or middle) then it deletes: when we delete more than one items (1st or any any items btween 1st and last) it deletes bt problem occurs when u r trying to delete more than one items  WITH THE LAST ITEM( 1st n last 3rd n last or any middle item and last...) then it gives you the following error.. :( Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index so give solution from your code or fix this above error.. thanx!!

Kirtan Patel · Answer

Hithanks for your wish :) Here it is project files in .Zip and with Updated Code for Check_All Functionality too :) Download Project Files(.Zip) for .zipx program WinZip v.12 or above is Used Important :- make CheckAll checkbox's AutoPostBack Propertie to True Check ALL Code (very simple just one foreach loop) ------------------------------- protected void CheckBox2_CheckedChanged( object sender EventArgs e) { if (CheckBox2.Checked == true ) { foreach ( GridViewRow r in GridView1.Rows) { (( CheckBox )GridView1.Rows[r.RowIndex].FindControl( CheckBox1 )).Checked = true ; } } else if (CheckBox2.Checked == false ) { foreach ( GridViewRow r in GridView1.Rows) { (( CheckBox )GridView1.Rows[r.RowIndex].FindControl( CheckBox1 )).Checked = false ; } } }

Dipa Ahuja · Answer

to Kirtan u too happy diwali n happy new year.. i download your project... it was in zipx format so i found zipx software to open zipx files bt still i coudnt extract it.. would u plz suggest any software for zipx file or send me project in jz ZIP format? n i one more thing.. i want to put one Checkbox at the top of checkbox .. by clicking on it all the checkboxex should be select and by diselecting all the checkboxes should bt disselected.. Thanx..!

Roei Bar · Answer

well my friend first i would like to recommend you to read this: article here is my explenation: in order to achive this you will need todo the following: GridViewRow row = GridView1.Rows[i]; bool isChecked = ((CheckBox) row.FindControl(  chkSelect )).Checked if (isChecked) { // execute a delete by the ROw Item Value executeDeleteBySelectedItem(row.FindControl( Item  ).Value) } another thing i could recommend you is a multi selected checkbox: here is the JS for this: HeaderTemplate > input id = chkAll onclick = javascript:SelectAllCheckboxes(this); runat = server type = checkbox / > / HeaderTemplate >  javascript > function SelectAllCheckboxes(spanChk){ // Added as ASPX uses SPAN for checkbox var oItem = spanChk.children; var theBox= (spanChk.type==  checkbox ) ? spanChk : spanChk.children.item[ 0 ]; xState=theBox.checked; elm=theBox.form.elements; for (i=0;i if (elm[i].type==  checkbox && elm[i].id!=theBox.id) { // elm[i].click(); if (elm[i].checked!=xState) elm[i].click(); // elm[i].checked=xState; } } script >

Kirtan Patel · Answer

Hi Diya First of all HAPPY DIWALI and HAPPY NEW Year :) Here is My Code Example to Do it check it out i also included my project files take a reference of it if you don't understand code here Download Project Files string ConnectionString = @Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True; protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { ShowDataInGrid(); } } protected void btnDelete_Click( object sender EventArgs e) { foreach ( GridViewRow r in GridView1.Rows) { //find Which Check Boxes are checked !! if ((( CheckBox )r.Cells[0].FindControl( CheckBox1 )).Checked == true ) { //Get the Username from column 1 and delete the row in database string UsernameToDelete = r.Cells[1].Text; //Delete the row in database according to Usernamevalue SqlConnection con = new SqlConnection ( ConnectionString); con.Open(); SqlCommand comm = new SqlCommand ( delete from Users where Username=' + UsernameToDelete + '  con); comm.ExecuteNonQuery(); con.Close(); } } //Finally Show Updated Data in GridView ShowDataInGrid(); } public void ShowDataInGrid() { SqlConnection con = new SqlConnection ( ConnectionString ); con.Open(); SqlCommand comm = new SqlCommand ( select * from users  con); GridView1.DataSource = comm.ExecuteReader(); DataBind(); con.Close(); }