为什么我动态生成的gridview无法显示数据？

Question

 public void setBind()
    {
        try
        {
            MyConnection.Open();            SqlCommand MyCommand = MyConnection.CreateCommand();
            
            MyCommand.CommandText = "Select distinct applyNum, statusname from UserPlan where planstatus = 1";
        
            SqlDataAdapter objAdapter = new SqlDataAdapter(MyCommand);
            DataSet ds = new DataSet();
            objAdapter.Fill(ds, "NewBind");            if (ds.Tables["NewBind"].Rows.Count > 0)
            {
                NewPlanTable.Columns.Clear();                BoundField applynum = new BoundField();
                applynum.DataField = ds.Tables["NewBind"].Columns["applyNum"].ToString();
                applynum.HeaderText = "需求申请号";
                applynum.Visible = true;
                NewPlanTable.Columns.Add(applynum);                BoundField status = new BoundField();
                status.DataField = ds.Tables["NewBind"].Columns["statusname"].ToString();
                status.HeaderText = "状态";
                status.Visible = true;
                NewPlanTable.Columns.Add(status);                NewPlanTable.DataBind();
            }        }
        catch (Exception e)
        {
            Response.Write(e.Message);
        }
        finally
        {
            MyConnection.Close();
        }
    }    （我在page_load里调用setBind()）

Answer 1

  SqlDataAdapter objAdapter = new SqlDataAdapter(MyCommand);
  DataSet ds = new DataSet();
  objAdapter.Fill(ds, "NewBind");前面声明了objAdapter 后面用ds 编译没报错？

Answer 2

NewPlanTable.DataBind();之前要加上NewPlanTable.DataSource = ds.Tables["NewBind"];