asp.net girdview 问题

Question

删除功能一按 就出现：索引超出范围。必须为非负值并小于集合大小。
参数名: indexpublic partial class _Default : System.Web.UI.Page 
{    public static SqlConnection create()
    {
        SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=4184085dsc;database=data;");
        return con;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            bind();
        
    }
    public void bind()
    {
        SqlConnection con = create();
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from db", con);
        SqlDataReader sdr = cmd.ExecuteReader();
        gv1.DataSource = sdr;
        gv1.DataBind();
        sdr.Close();
        con.Close();
    }    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
       gv1.EditIndex = e.NewEditIndex;
        bind();
    }    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string sqlstr = "delete from db where id='" + gv1.DataKeys[e.RowIndex].Value.ToString() + "'";
        SqlConnection con = create();
        con.Open();
        SqlCommand cmd = new SqlCommand(sqlstr, con);        cmd.ExecuteNonQuery();
        con.Close();
        bind();
    }}

Answer 1

检查一下：e.RowIndex，是否小于总行数，且大于等于0

Answer 2

调试一下。看看e.rowIndex 的结果！

Answer 3

GridView绑定数据的时候是否设置主键
GridView.DataKeyNames = new string[] { "主键" };