GridView删除行

最新推荐文章于 2024-12-13 12:21:09 发布

转载最新推荐文章于 2024-12-13 12:21:09 发布 · 6.5k 阅读

标签

#dataset #server #asp #database #delete

asp.net 专栏收录该内容

11 篇文章

订阅专栏

本文介绍如何在ASP.NET中使用GridView控件实现数据展示及删除功能。通过C#代码连接SQL Server数据库并填充GridView，利用模板字段添加删除按钮，弹窗确认后执行删除操作并刷新页面。

HTML code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDeleting="GridView1_RowDeleting"> <Columns> <asp:BoundField DataField="id" HeaderText="id" /> <asp:BoundField DataField="name" HeaderText="name" /> <asp:TemplateField ShowHeader="False"> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" Text="删除" OnClientClick='<%# "if (!confirm(/"你确定要删除" + Eval("name").ToString() + "吗?/")) return false;"%>'></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>

C# code
private void BindGridView() { SqlConnection cn = new SqlConnection(@"server=./SQLExpress;uid=sa;pwd=;database=Demo"); SqlDataAdapter da = new SqlDataAdapter("select id, name from yourtable", cn); DataSet ds = new DataSet(); cn.Open(); da.Fill(ds); cn.Close(); GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataKeyNames = new string[] { "id" }; GridView1.DataBind(); } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindGridView(); } } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string strSql = "delete from yourtable where id = @id"; SqlConnection cn = new SqlConnection(@"server=./SQLExpress;uid=sa;pwd=;database=Demo"); SqlCommand cmd = new SqlCommand(strSql, cn); cmd.Parameters.Add("@id", SqlDbType.VarChar, 11).Value = GridView1.DataKeys[e.RowIndex].Value.ToString(); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); BindGridView(); }