protected void Page_Load(object sender, EventArgs e)
        {
                      if (Request.QueryString["id"] != null)
                {
                    mymis.BLL.jobplan20 bll = new mymis.BLL.jobplan20();
                    decimal id = Convert.ToDecimal(Request.QueryString["id"]);
                    bll.Delete(id);
                  sql1.SelectCommand = "SELECT * FROM [jobplan20] WHERE belongto='" + User.Identity.Name + "' ORDER BY [addtime] DESC";
                    GridView1.DataSourceID = "sql1";
                    //     rd.DataBind();
                    //    GridView1.DataBind();
                    GridView1.DataBind();
                    //   Page.DataBind();
                    MessageBox.ShowAndRedirect(this, "删除成功", "list.aspx");
                }             
            if (rd.SelectedValue == "all")
            {
                sql1.SelectCommand = "SELECT * FROM [jobplan20] WHERE belongto='" + User.Identity.Name + "' ORDER BY [addtime] DESC";
                GridView1.DataBind();
            }
            else
            {
                sql1.SelectCommand = "SELECT * FROM [jobplan20] WHERE belongto='" + User.Identity.Name + "' and myyear='" + rd.SelectedValue.Trim() + "' ORDER BY [addtime] DESC";
                GridView1.DataBind();
            }
    
        }

        protected void rd_DataBound(object sender, EventArgs e)
        {
            sql1.SelectCommand = "SELECT * FROM [jobplan20] WHERE belongto='"+User.Identity.Name +"' ORDER BY [addtime] DESC";
            GridView1.DataBind();
        }

        protected void rd_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (rd.SelectedValue == "all")
            {
                sql1.SelectCommand = "SELECT * FROM [jobplan20] WHERE belongto='" + User.Identity.Name + "' ORDER BY [addtime] DESC";
                GridView1.DataBind();
            }
            else
            {
                sql1.SelectCommand = "SELECT * FROM [jobplan20] WHERE belongto='" + User.Identity.Name+"' and myyear='"+rd.SelectedValue.Trim() + "' ORDER BY [addtime] DESC";
                GridView1.DataBind();
            }

        }

前台 gridview 删除代码

      <asp:TemplateField ShowHeader="False">
                    <ItemTemplate>
                            <a href="list.aspx?id=<%#Eval("id") %>">删除</a>
                    </ItemTemplate>
                    <ItemStyle Width="50px" />
                </asp:TemplateField>


Gridview 是和下拉列表动态绑定的,可是一点删除按钮后,gridview 就不显示数据了, 该绑定的我也绑定了啊, 在这卡了两天了,请各位指点一下!

posted on 2010-01-31 18:49  龙战  阅读(527)  评论(0)    收藏  举报