说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.ArgumentOutOfRangeException: 索引超出范围。必须为非负值并小于集合大小。
参数名: index
上网查了下解决方法,发现网上下面的答到了重点:
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
sqlcon.Close();
然后写SQL语句:select 字段A,字段B where id=‘"+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "‘";
而我的错误原因就是因为我没有设置主键,也就是DataKeyNames
附上我的详细代码,请自己参考下面的主要代码
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = Createcon();
conn.Open();
OleDbCommand cmd = new OleDbCommand("select * from adimn", conn);
OleDbDataReader dr = cmd.ExecuteReader();
this.GridView1.DataSource = dr;
this.GridView1.DataKeyNames = new string[] { "id"} ;
this.GridView1.DataBind();
dr.Dispose();
conn.Close();
}
//数据库连接
protected OleDbConnection Createcon()
{
return new OleDbConnection("Provider = Microsoft.JET.OleDB.4.0;Data Source = |DataDirectory|admin.mdb");
}
//删除数据
protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
OleDbConnection conn = Createcon();
conn.Open();
OleDbCommand cmd = new OleDbCommand("Delete from adimn where id = " + GridView1.DataKeys[e.RowIndex].Value, conn);
cmd.ExecuteNonQuery();
cmd.CommandText = "select * from adimn";
OleDbDataReader dr = cmd.ExecuteReader();
this.GridView1.DataSource = dr;
this.GridView1.DataBind();
dr.Dispose();
conn.Close();
}
}