GridView实现双击进行编辑，更新

虽然标题是原创，但是其实主要的思想呢还是接见了晓风残月的思路，今天在晓风残月的博客上看到了如何利用GridView来实现双击进行编辑。我决定动手实现一下，由于还没有实现双击进行更改操作，所以顺便就把这个功能加了上去，希望对大家能有帮助，同时也谢谢晓风残月。

效果图如下：

前台代码

 

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
            BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" OnRowEditing="GridView1_RowEditing" OnRowDataBound="GridView1_RowDataBound" OnRowUpdating="GridView1_RowUpdating" OnRowCommand="GridView1_RowCommand">
            <FooterStyle BackColor="White" ForeColor="#000066" />
            <Columns>
                <asp:ButtonField Text="SingleClick" CommandName="SingleClick" Visible="false" ButtonType="Link"/>
                <asp:TemplateField HeaderText="ID">
                    <ItemTemplate>
                        <%...# Eval("customerid")%>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="ID" runat ="server" Text='<%# Bind("customerid")%>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CompanyName">
                    <ItemTemplate>
                        <%...# Eval("CompanyName")%>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="CName" runat ="server" Text='<%# Bind("CompanyName")%>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="ContactName">
                    <ItemTemplate>
                        <%...# Eval("ContactName")%>
                    </ItemTemplate>
                    <EditItemTemplate>
                         <asp:TextBox ID="Name" runat ="server" Text='<%# Bind("ContactName")%>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Address">
                    <ItemTemplate>
                        <%...# Eval("Address")%>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="Address" runat ="server" Text='<%# Bind("Address")%>'></asp:TextBox>
                    </EditItemTemplate>
                </asp:TemplateField>
            </Columns>
            <RowStyle ForeColor="#000066" />
            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
        </asp:GridView>
    
    </div>
    </form>

 

后台代码

 

    string ConStr = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
        ...{
            BindData();
        }
    }


    private void BindData()
    ...{

        SqlConnection MyCon = new SqlConnection(ConStr);
        string QueryStr = "SELECT customerid,CompanyName,ContactName,Address FROM customers";
        SqlDataAdapter Da = new SqlDataAdapter(QueryStr, MyCon);
        DataSet Ds = new DataSet();
        Da.Fill(Ds, "Customers");
        GridView1.DataSource = Ds.Tables[0];
        GridView1.DataKeyNames = new string[] ...{ "customerid" };
        GridView1.DataBind();

    }

    protected override void Render(HtmlTextWriter writer)
    ...{
        foreach (GridViewRow Row in GridView1.Rows)
        ...{
            if (Row.RowType == DataControlRowType.DataRow)
            ...{
                //双击进入编辑模式
                Row.Attributes["ondblclick"] = ClientScript.GetPostBackEventReference(GridView1, "Edit$" + Row.RowIndex.ToString(), true);
                Row.Attributes["style"] = "cursor:pointer";
                Row.Attributes["title"] = "双击进入编辑";
                if (Row.RowState == DataControlRowState.Edit)
                ...{
                    Row.Attributes.Remove("ondblclick");
                    Row.Attributes.Remove("style");
                    Row.Attributes["title"] = "编辑行";
                    for (Int32 i = 1; i < GridView1.Columns.Count; i++)
                    ...{
                        ((TextBox)Row.Cells[i].Controls[1]).Attributes.Add("onmouseover", "this.select()");

                    }
                    //双击更新
                    Row.Attributes["ondblclick"] = ClientScript.GetPostBackEventReference(GridView1, "Update$" + Row.RowIndex.ToString(), true);

                }
                //
                for (int i = 1; i < Row.Cells.Count; i++)
                ...{
                    Page.ClientScript.RegisterForEventValidation(Row.UniqueID + "$ctl00", i.ToString());
                }
            }
        }
        base.Render(writer);
    }


    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    ...{
        GridView1.EditIndex = e.NewEditIndex;
        BindData();
    }


    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    ...{
        string ID = GridView1.DataKeys[e.RowIndex].Value.ToString();
        //防止非法的输入，预防脚本攻击
        string CustomerId = Server.HtmlDecode(((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[1]).Text.ToString());
        string CompanyName = Server.HtmlDecode(((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[1]).Text.ToString());
        string ContactName = Server.HtmlDecode(((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[1]).Text.ToString());
        string Address = Server.HtmlDecode(((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[1]).Text.ToString());
        SqlConnection Con = new SqlConnection(ConStr);
        string UpdateStr = "UPDATE customers SET companyname=@CompanyName,contactname=@ContactName,address=@Address  WHERE customerid=@ID";
        //插入数据的时候用参数来可以预防SQL注入攻击，提高系统的安全性
        SqlCommand UpdateCmd = new SqlCommand(UpdateStr,Con);
        SqlParameter ParmID = new SqlParameter("@ID", SqlDbType.NVarChar,20);
        ParmID.Value = ID;
        SqlParameter ParmCName = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 20);
        ParmCName.Value = CompanyName;
        SqlParameter ParmName = new SqlParameter("@ContactName",SqlDbType.NVarChar,20);
        ParmName.Value = ContactName;
        SqlParameter ParmAddr = new SqlParameter("@Address",SqlDbType.NVarChar,20);
        ParmAddr.Value = Address;
        try
        ...{
            UpdateCmd.Parameters.Add(ParmCName);
            UpdateCmd.Parameters.Add(ParmName);
            UpdateCmd.Parameters.Add(ParmAddr);
            UpdateCmd.Parameters.Add(ParmID);
            Con.Open();
            UpdateCmd.ExecuteNonQuery();
            Con.Close();
        }
        catch
        ...{
            ShowMessage("输入格式不正确，请检查");
        }
        finally
        ...{
            Con.Close();
            GridView1.EditIndex = -1;
            BindData();
        }
    }

    private void ShowMessage(string Message)
    ...{
        Literal TxtMsg = new Literal();
        TxtMsg.Text = "<script>alert('" + Message + "')</script>";
        Page.Controls.Add(TxtMsg);
    }


    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    ...{

    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    ...{
        GridView ControlGridView = (GridView)sender;
        if (e.CommandName == "SingleClick")
        ...{
            int RowIndex = int.Parse(e.CommandArgument.ToString());
            int ColIndex = int.Parse(Request.Form["__EVENTARGUMENT"]);
            Response.Write("<script>alert('你点击了第"+(RowIndex+1)+"行的第"+(ColIndex)+"列');</script>");

        }
    }
}