Question

gridview编辑、删除

access数据库，user表,id name两个字段分别为1；张三。2；李四
拖一个gridview到页面，绑定数据源，我怎么写编辑和删除的方法？听别人说要设ID为主键。高手给写个详细点的例子，谢谢了。

Answer 1

gridview 添加删除列，点击的时候取得列[id]的值
执行sql语句 ExecuteNonQuery("delete from user where id ="+id)

编辑的时候 update就可以

Answer 2

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="6" ForeColor="#333333" GridLines="None" OnRowDeleting="GridView1_RowDeleting"
OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:BoundField DataField="name" HeaderText="姓名" ReadOnly="True" />
<asp:CommandField UpdateText="保存" ShowEditButton="True" CancelText="取消" DeleteText="删除" EditText="编辑" >
</asp:CommandField>
<asp:CommandField DeleteText="删除" ShowDeleteButton="True" />
</Columns>
</asp:GridView>

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//删除
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
//编辑
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
//取消（编辑）
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//保存（编辑）
}