GridView编辑删除操作

原创 2011年10月31日 15:43:04
 

  第一种:使用DataSource数据源中自带的编辑删除方法,这种不常用,在这里就不加说明了。

  第二种:使用GridView的三种事件:GridView1_RowEditing(编辑)、GridView1_RowUpdating(更新)、GridView1_RowCancelingEdit(取消编辑)。GridView1属性中将DataKeyNames的值设置为主键名,否则找不到索引,这个很重要哦。

该方法有2种操作,一种是不对绑定列转换为模板列,另外一种是转换为模板列。

 

这里先说不转换为模板列的情况;

 

首先;先对GridView进行数据绑定,不管用代码绑定还是DataSource绑定都可以。绑定好后,对GridView添加绑定列 和编辑列 (注意这里,添加好后不做任何改动,千万不要将它们转换为模板列),添加好后,将所要绑定的数据库表字段填入 属性中。

然后,分别激活上述提到的三种事件,然后添加代码:

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{ //执行删除

string str = "delete from tb_hby where id='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";

    db.Delete(str); //db是操作类的实例,Delete是删除数据的方法

this.GridView1.DataBind();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{//执行更新

    string cell1 = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();//第一列注意这种写法很重要

     string cell2 = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();//第二列注意这种写法很重要

     string str = "update tb_hby set hby_title='" + cell1 + "',hby_Datetime='" + cell2 + "' where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

        db.Update(str);//db是操作类的实例,Update是更新数据的方法

        GridView1.EditIndex = -1;

        GView();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

 {//激活编辑按钮的事件

        this.GridView1.EditIndex = e.NewEditIndex;

        GView();

 }

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {//取消编辑状态的事件

        GridView1.EditIndex = -1;

        GView();

}

说明:此方法中,如果要求某个绑定列不做编辑,则在它的前台代码中加入ReadOnly=”true”即可。

此方法有一些缺点,比如对日期列进行格式化时,显示的时候是格式化后的日期,但是在编辑状态下仍然显示出日期的原貌,还有,某一列的字符太长时,不好对它进行字符截取。

在点击删除按钮的时候,如果需要一个弹出删除提示,则要将删除列转化为模板列,其代码如下:

<ItemTemplate>

  <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" OnClientClick="return confirm('确定要删除吗?')"                     Text="删除"></asp:LinkButton>

</ItemTemplate>

也可以这样写:

在RowDataBind事件中:

if (e.Row.RowType == DataControlRowType.DataRow)

        {

            LinkButton lnkdelete = (LinkButton)e.Row.FindControl("lnkdelete");

            lnkdelete.Attributes.Add("onclick","return confirm('您确定要删除吗?')");

        }

如果不转化为模板列,这这样写:

if (e.Row.RowType == DataControlRowType.DataRow)

        {

            if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

            {

                //((LinkButton)e.Row.Cells[7].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:\"" + e.Row.Cells[0].Text + "\"吗?')");

                ((LinkButton)e.Row.Cells[7].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除吗?')");

            }

        }

完整代码如下:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowUpdating="GridView1_RowUpdating">

            <Columns>

                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"  SortExpression="id" />

 

                <asp:BoundField DataField="hby_Title" HeaderText="hby_Title"  SortExpression="hby_Title" AccessibleHeaderText="fgfg" />

 

                <asp:BoundField DataField="hby_Datetime" DataFormatString="{0:HH:mm}"  />

                <asp:CommandField ShowEditButton="True" />

                <asp:TemplateField ShowHeader="False">

                    <ItemTemplate>

                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" OnClientClick="return confirm('确定要删除吗?')"

                            Text="删除"></asp:LinkButton>

                    </ItemTemplate>

                </asp:TemplateField>

            </Columns>

        </asp:GridView>

 

后台代码:

public partial class Default3 : System.Web.UI.Page

{

    DBconn db = new DBconn();

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            GView();

        }

    }

 

    private void GView()

    {

        string strbind = "select id,hby_title,hby_Datetime from tb_hby order by id desc";

        this.GridView1.DataSource = db.getDataSet(strbind);

        this.GridView1.DataBind();

    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

    {

        string str = "delete from tb_hby where id='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";

        db.Delete(str);

        this.GridView1.DataBind();

    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

    {

        this.GridView1.EditIndex = e.NewEditIndex;

        GView();

    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

        string cell1 = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();//第一列

        string cell2 = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();//第二列

        string str = "update tb_hby set hby_title='" + cell1 + "',hby_Datetime='" + cell2 + "' where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

        db.Update(str);//db是操作类的实例,Update是更新数据的方法

        GridView1.EditIndex = -1;

        GView();

    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {

        GridView1.EditIndex = -1;

        GView();

    }

}

 

 

以下是对绑定列转换为模板列的操作(包括将编辑列和删除列都转化为模板列):

private void GView()

{//绑定数据源

   string strbind = "select top 15 id,hby_title,hhhhh,hby_Datetime from tb_hby";

   this.GridView1.DataSource = db.getDataSet(strbind);

   this.GridView1.DataBind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{//执行删除

   string str = "delete from tb_hby where id='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'";

   db.Delete(str);

    //GView();

    Response.Write("<script language='JavaScript'>");

    Response.Write("alert('删除成功!');location.href='default3.aspx';");

    Response.Write("</script>");

 }

 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

 {//激活编辑

        this.GridView1.EditIndex = e.NewEditIndex;

        GView();

 }

 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

 {//执行更新

string EditTitle = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox1"))).Text.ToString().Trim();

   string DateTimestr = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox2"))).Text;//注意:日期字段不要加ToString(),否则会报错,而nvarchar和int的字段可以加

    string hhh = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox3"))).Text.ToString();

   string str = "update tb_hby set hby_title='" +EditTitle + "',hby_Datetime='" + DateTimestr + "',hhhhh='"+hhh+"' where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

   db.Update(str);

   GridView1.EditIndex = -1;

   GView();

 }

 

这里千万要注意

当对绑定列转换为模板列了之后,编辑列这样写:

string EditTitle = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox1"))).Text.ToString().Trim();

不转化为模板列的时候,编辑列这样写:

string EditTitle = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();

 

这里容易搞错,以致经常发生疑惑。

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

 {//取消编辑状态

        GridView1.EditIndex = -1;

        GView();

 }

 

以下是前台代码:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowUpdating="GridView1_RowUpdating">

            <Columns>

                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"

                    SortExpression="id" />

                <asp:TemplateField AccessibleHeaderText="fgfg" HeaderText="hby_Title" SortExpression="hby_Title">

                    <EditItemTemplate>

                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("hby_Title") %>'></asp:TextBox>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("hby_Title") %>'></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField>

                    <EditItemTemplate>

                        <asp:TextBox ID="TextBox2" runat="server" Text='<%#  Eval("hby_Datetime", "{0:HH:mm}") %>'></asp:TextBox>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label2" runat="server" Text='<%# Eval("hby_Datetime", "{0:HH:mm}") %>'></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="好">

                    <EditItemTemplate>

                        <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("hhhhh") %>'></asp:TextBox>

                    </EditItemTemplate>

                    <ItemTemplate>

                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("hhhhh") %>'></asp:Label>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField ShowHeader="False">

                    <EditItemTemplate>

                        <asp:LinkButton ID="LkBtnUpdate" runat="server" CausesValidation="True" CommandName="Update"

                            Text="更新"></asp:LinkButton>

                        <asp:LinkButton ID="LkBtnCtrl" runat="server" CausesValidation="False" CommandName="Cancel"

                            Text="取消"></asp:LinkButton>

                    </EditItemTemplate>

                    <ItemTemplate>

                         <img src="img/edt.gif" /><asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Edit"

                            Text="编辑"></asp:LinkButton>

                    </ItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField ShowHeader="False" HeaderText="删除">

                    <ItemTemplate>

                       <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" OnClientClick="return confirm('确定要删除吗?')"

                            Text="删除"></asp:LinkButton>

                    </ItemTemplate>

                </asp:TemplateField>

            </Columns>

        </asp:GridView>

 

以上绑定中,无论是Eval或者Bind都可以。

 

 

  第三种方法:将编辑和显示都放在模板列中,代码如下:

前台绑定:

<asp:TemplateField HeaderText="出团日期">

    <ItemTemplate>

      <asp:TextBox ID="tbx_ctrq" runat="server" Text='<%# Eval("cspd_ctrq") %>' Visible="false"></asp:TextBox>

      <asp:Label ID="lbl_ctrq" runat="server" Text='<%# Eval("cspd_ctrq") %>'></asp:Label>

   </ItemTemplate>

  <ControlStyle Width="84px" />

</asp:TemplateField>

<asp:TemplateField HeaderText="价格">

   <ItemTemplate>

   <asp:TextBox ID="tbx_price" runat="server" Text='<%# Eval("cspd_price") %>' Visible="false"></asp:TextBox>

   <asp:Label ID="lbl_price" runat="server" Text='<%# Eval("cspd_price") %>'></asp:Label>

 </ItemTemplate>

  <ControlStyle Width="60px" />

</asp:TemplateField>

 

<asp:TemplateField HeaderText="编辑" ShowHeader="False">

  <ItemTemplate>

    <asp:LinkButton ID="LB_edit" runat="server" CausesValidation="False" CommandArgument='<%# ((GridViewRow) Container).RowIndex %>' CommandName="iEdit" Text="编辑"></asp:LinkButton>

   <asp:LinkButton ID="LB_upd" runat="server" CausesValidation="True" CommandName="iUpdate"

       Visible="false" CommandArgument='<%# ((GridViewRow) Container).RowIndex %>' Text="更新"></asp:LinkButton>

   <asp:LinkButton ID="LB_cancel" runat="server" CausesValidation="False" CommandName="iCancel" Visible="false" CommandArgument='<%# ((GridViewRow) Container).RowIndex %>' Text="取消"></asp:LinkButton>

  </ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="删除">

  <ItemTemplate>

   <asp:LinkButton ID="LB_Del" runat="server" OnClientClick="return confirm('确定要删除吗?')"

       CommandName="Delete" Text="删除"></asp:LinkButton>

  </ItemTemplate>

</asp:TemplateField>

 

 

后台代码如下:

protected void GV_Main_RowCommand(object sender, GridViewCommandEventArgs e)

    {

        if (e.CommandName == "iEdit")

        {

            int rowIndex = Convert.ToInt32(e.CommandArgument);

            ((LinkButton)GV_Main.Rows[rowIndex].FindControl("LB_edit")).Visible = false;

            ((LinkButton)GV_Main.Rows[rowIndex].FindControl("LB_upd")).Visible = true;

            ((LinkButton)GV_Main.Rows[rowIndex].FindControl("LB_cancel")).Visible = true;

 

            ((Label)GV_Main.Rows[rowIndex].FindControl("lbl_chanpin")).Visible = false;

            ((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_chanpin")).Visible = true;

 

            ((Label)GV_Main.Rows[rowIndex].FindControl("lbl_ctrq")).Visible = false;

            ((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_ctrq")).Visible = true;

        }

        if (e.CommandName == "iCancel")

        {

            int rowIndex = Convert.ToInt32(e.CommandArgument);

            ((LinkButton)GV_Main.Rows[rowIndex].FindControl("LB_edit")).Visible = true;

            ((LinkButton)GV_Main.Rows[rowIndex].FindControl("LB_upd")).Visible = false;

            ((LinkButton)GV_Main.Rows[rowIndex].FindControl("LB_cancel")).Visible = false;

 

            ((Label)GV_Main.Rows[rowIndex].FindControl("lbl_chanpin")).Visible = true;

            ((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_chanpin")).Visible = false;

 

            ((Label)GV_Main.Rows[rowIndex].FindControl("lbl_ctrq")).Visible = true;

            ((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_ctrq")).Visible = false;

        }

        if (e.CommandName == "iUpdate")

        {

            int rowIndex = Convert.ToInt32(e.CommandArgument);

            if (!wpf.IsNum(((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_price")).Text.Trim()))

            {

                Page.ClientScript.RegisterStartupScript(this.GetType(), "Startup", "<script>alert('价格必须是数字!');</script>");

            }

             string strupd = "UPDATE [tb_cspd] SET [cspd_chanpin] = '" + wpf.checkStr(((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_chanpin")).Text.Trim()) + "', [cspd_ctrq] = '" + wpf.checkStr(((TextBox)GV_Main.Rows[rowIndex].FindControl("tbx_ctrq")).Text.Trim()) + "', WHERE [id] = " + GV_Main.DataKeys[rowIndex][0].ToString();

 

                //Response.Write(strupd);

                wpf.SqlQuery(strupd);

                GV_Main.DataBind();

            }

        }

}

 

 

 

点击编辑按钮后统一列在文本框中进行编辑:

效果:

首先还是在GridView1属性中DataKeyNames的值设置为主键名

前台代码:

<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" OnRowCommand="GridView3_RowCommand" DataKeyNames="News_Id">

                        <Columns>

                            <asp:BoundField DataField="News_Title" HeaderText="标题" />

                            <asp:BoundField DataField="News_Source" HeaderText="来源" />

                            <asp:BoundField DataField="News_Date" HeaderText="日期" />

                            <asp:TemplateField HeaderText="编辑">

                                <ItemTemplate>

                                    <asp:LinkButton ID="LkBtnbianji" runat="server" CommandName="edit_ok" CommandArgument='<%# ((GridViewRow) Container).RowIndex  %>'>编辑</asp:LinkButton>

                                </ItemTemplate>

                            </asp:TemplateField>

                        </Columns>

                    </asp:GridView>

 

后台代码:

private void GView3()

    {

        string strbind = "select News_Id,News_Title,News_Source,News_Date from tb_News";

        this.GridView3.DataSource = db.getDataSet(strbind);

        this.GridView3.DataBind();

    }

    protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)

    {

        if (e.CommandName == "edit_ok")

        {

            int rowIndex = Convert.ToInt32(e.CommandArgument);

            string strbind = "select News_Id,News_Title,News_Source,News_Date from tb_News where News_Id=" + GridView3.DataKeys[rowIndex][0].ToString();

            DataRow dr = db.getDataSet(strbind).Tables[0].Rows[0];

            this.BunAdd.CommandArgument = GridView3.DataKeys[rowIndex][0].ToString();

            this.TextTitle.Text = dr["News_Title"].ToString();

            this.TextType.Text=dr["News_Source"].ToString();

            this.TextDatetime.Text = dr["News_Date"].ToString();

        }

    }

    protected void BunAdd_Click(object sender, EventArgs e)

    {

        string up = "update tb_News set News_Title='" + this.TextTitle.Text.Trim() + "',News_Source='" + this.TextType.Text.Trim() + "',News_Date='" + this.TextDatetime.Text.Trim() + "' where News_Id="+BunAdd.CommandArgument;

        db.Update(up);

        GView3();

    }

相关文章推荐

gridview数据增删改查(当前行操作)

A前台代码                                                                      ...

ASP.NET中GridView控件删除数据的两种方法

今天在用GridView控件时,发现了一个问题,就是使用GridView控件在删除数据时的问题。接下来我们通过模板列方式和CommandField方式删除某条数据讲解下两者之间的区别。    方式一...

GridView控件的编辑、删除、更新、取消!

原文出处:http://juntalk.com/gridviewbqg.html 个人觉得真的写的非常好!大家去看下支持下! 上次讲到《用GridView控件来实现搜索功能》,...
  • ergouge
  • ergouge
  • 2012年07月23日 21:37
  • 4766

删除GridView中的一行的-----两种操作方法.

在GridView中的编辑列中添加一方法1:                                     (不转为TemplateField)                删除之前弹出"...

GridView中直接新增行、编辑和删除

.aspx "server" ID="btnAdd" Text="新增" OnClick="btnAdd_Click" />    "gv" runat="server" Al...

实现对gridview删除行时弹出确认对话框的一种简单方法

在VS2008提供的GridView中我们可以直接添加一个CommandField删除列:,完后在它的RowDeleting事件中完成删除。但在多半我们在做这种删除操作时都需要先让操作者再确认下,完后...

devExpress GridView删除行的几种方式

一直以来,GridView的行删除,没的搞清楚。 以前是这样实现的,当然也可行,方法是第一步在Dataset中,加一个删除用的函数,然后删除之。         private void grid...

自定义GRIDVIEW编辑列 删除列

自定义gridview的编辑和删除列,来操作数据库

GridView的编辑、增加、删除功能

ASPNET2.0以后,数据的表格显示统一为GridView控件,其与数据库控件(如:SqlDataSource)配合使用后,不用编写代码就可以容易进行数据的增加、编辑和删除,现以SqlDataSou...

GridView行编辑、更新、取消、删除事件用法

注意:当启用编辑按钮时,点击编辑按钮后会使一整行都切换成文本框。为了是一行中的一部分是文本框,需要把以整行的所有列都转换成模板,然后删掉编辑模板中的代码。这样就能使你想编辑的列转换成文本框。 1.界...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:GridView编辑删除操作
举报原因:
原因补充:

(最多只允许输入30个字)