datagrid里删除数据

    public void People_Delete(Object sender, DataGridCommandEventArgs e)
    {
        SqlConnection connDel = Operate.createCon();
        connDel.Open();
        String sql_Del = "DELETE FROM dkh WHERE dkh_autoid = " + e.Item.Cells[0].Text;

        SqlCommand sqlCommandDel = new SqlCommand(sql_Del, connDel);
        sqlCommandDel.ExecuteNonQuery();
        connDel.Close();
        SqlConnection conn = Operate.createCon();

        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from dkh", conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "per");
        this.DataGrid1.DataSource = ds.Tables["per"];
        this.DataGrid1.DataBind();

    }

前台    <asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" Width="434px" OnDeleteCommand="People_Delete" OnItemDataBound="grid_ReceiptList1_ItemDataBound">//添加的按钮名,和删除对话框
        <Columns>
            <asp:BoundColumn DataField="dkh_autoid" HeaderText="ID"></asp:BoundColumn>
            <asp:BoundColumn DataField="dkh_name" HeaderText="名子"></asp:BoundColumn>
            <asp:BoundColumn DataField="dkh_sex" HeaderText="性别"></asp:BoundColumn>
            <asp:ButtonColumn CommandName="Delete" HeaderText="删除" Text="删除"></asp:ButtonColumn>
        </Columns>
    </asp:DataGrid>

    protected void grid_ReceiptList1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemIndex != -1)
        {
            //setDelMsg(e, "Delete", "真的要删除吗？");

            LinkButton lb = (LinkButton)e.Item.Cells[6].Controls[0];

            lb.Attributes.Add("onclick", "return confirm('真的要删除吗？')");
            //Response.Write(e.Item.Cells[6].Controls[0].ToString());

        }
    }