ALL THING OF COMPUTER SCIENCE(DOTNET ,C#,C,SQLSERVER,OPERATING SYSTEM
Yogendra Pratap Singh
Wednesday, 16 November 2011
girdview values delete by combo box in asp.net
HTML clipboard
asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" AllowPaging ="true" DataKeyNames ="Roll">
<Columns>
<asp:TemplateField HeaderText="ROLL">
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" Text='<%# Eval("Roll") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
</Columns>
</asp:GridView>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:goelConnectionString %>"
SelectCommand="SELECT * FROM [stu]"></asp:SqlDataSource>
</div>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
style="width: 74px" Text="DELETE" />
</form>
protected void Button1_Click(object sender, EventArgs e)
{
bool atLeastOneRowDeleted = false;
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("CheckBox1");
if (cb != null && cb.Checked)
{
atLeastOneRowDeleted = true;
// First, get the ProductID for the selected row
int productID = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value); // "Delete" the row
SqlConnection sq = new SqlConnection("data source=MCQL;initial catalog=goel;user id=sa;password=lko.123");
sq.Open();
SqlCommand cmd = new SqlCommand("delete from stu where Roll='" + productID.ToString() + "'", sq);
cmd.ExecuteNonQuery();
Label1.Text += string.Format("This would have deleted ProductID {0}<br />", productID);
}
// Show the Label if at least one row was deleted...
Label1 .Visible = atLeastOneRowDeleted;
}
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment