为什么datalist删除一条记录,但要再刷新页面才能显示出来

Question

 protected void DataList1_ItemCommand(object sender, DataListCommandEventArgs e)
    {
        if (e.Item.ItemIndex != -1 && e.CommandName == "DRdel")//判断索引和CommandName
        {
            int id = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex].ToString());
            OleDbConnection conn = db.CreateConnection();
            conn.Open();
            string sql = "delete from Img where ID=" + id;
            OleDbCommand cmd = new OleDbCommand(sql, conn);
            cmd.ExecuteNonQuery();
            img();
           
            
            
        }
           protected void img()
    {
        
        string sql = "select * from Img order by id desc";
        ISqlOper sqlOper = new SqlOper();
        PagedDataSource ps = new PagedDataSource();        ps.DataSource = sqlOper.ReadData(sql).Tables[0].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 9;
        ps.CurrentPageIndex = Convert.ToInt32(curpage.Text) - 1;
        allpage.Text = Convert.ToString(ps.PageCount);
        try
        {
            DataList1.DataSource = ps;            //初始化下拉列表---------
            int i = 1;
            pagelist.Items.Clear();            while (i <= ps.PageCount)
            {
                pagelist.Items.Add(new ListItem(Convert.ToString(i), Convert.ToString(i)));
                i = i + 1;
            }
            pagelist.SelectedIndex = int.Parse(curpage.Text) - 1;
            //结束            first.Enabled = true;
            pre.Enabled = true;
            next.Enabled = true;
            last.Enabled = true;            if (curpage.Text == "1")
            {
                first.Enabled = false;
                pre.Enabled = false;
            }
            if (curpage.Text == allpage.Text)
            {
                next.Enabled = false;
                last.Enabled = false;
            }
            DataList1.DataBind();        }

Answer 1

protected void DataList1_ItemCommand(object sender, DataListCommandEventArgs e)
  {
  if (e.Item.ItemIndex != -1 && e.CommandName == "DRdel")//判断索引和CommandName
  {
  int id = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex].ToString());
  OleDbConnection conn = db.CreateConnection();
  conn.Open();
  string sql = "delete from Img where ID=" + id;
  OleDbCommand cmd = new OleDbCommand(sql, conn);
  cmd.ExecuteNonQuery();
  Response.Refirect(Request.URL.ToString());//重新跳转到当前页面，以重新绑定数据
   
   
   
  }