Dear Experts,
Please can u suggest me Code..for Deleting records from Gridview using Checkbox in asp.net.
I do not know what is the row index
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
onselectedindexchanging="GridView1_SelectedIndexChanging" Width="26px"
onrowcreated="GridView1_RowCreated" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox runat="server" ID="CheckBoxItem" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Username" HeaderText="Username" />
<asp:BoundField DataField="VideoTitle" HeaderText="VideoTitle" />
<asp:BoundField DataField="LineDescription" HeaderText="Comment" />
<asp:BoundField DataField="RegDate" HeaderText="RegDate"/>
<asp:BoundField DataField="RegTime" HeaderText="RegTime" />
<asp:CommandField ShowSelectButton="True" SelectText="Show" />
</Columns>
</asp:GridView>
protected void Button1_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvr in GridView1.Rows)
{
if (((CheckBox)gvr.FindControl("CheckBoxItem")).Checked == true)
{
int Index=gvr.RowIndex;
string cid = ds.Tables[0].Rows[Index]["CID"].ToString();
string delCM = string.Format("Delete Comments where CID={0}", cid);
int r = dbm.DeleteFromDB(delCM);
}
}
}