大家帮我看代码有什么问题，DataGird更新不到新数据！谢谢

Question

点更新，还是以前的数据没变，我用Result.Text（是一个 Label）显示了一下。结果数据没有更新

Answer 1

Conn = new SqlConnection("server=localhost;database=StudentBook;uid=sa;pwd='ibm'"); 
if (!Page.IsPostBack) 
    startIndex = 0; 
BindGrid(); 改成
if (!Page.IsPostBack) 
{
    Conn = new SqlConnection("server=localhost;database=StudentBook;uid=sa;pwd='ibm'"); 
    startIndex = 0; 
    BindGrid(); 
}
试试

Answer 2

我的是这么实现的:   protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            band();
        }
    }
    private void band()
    {
        string connString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        SqlConnection con = new SqlConnection(connString);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select * from Capital order by newid()", con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
        con.Close();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        band();
    }    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        band();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {        string connString=ConfigurationManager.AppSettings["ConnectionString"].ToString();
        SqlConnection con = new SqlConnection(connString);
        con.Open();
        string aa = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
        string bb = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString();
        string cc = "update Capital set capitalcode='" + bb + "' where DomainID='" + aa + "'";
        SqlCommand cmd = new SqlCommand(cc, con);
        cmd.ExecuteNonQuery();
        con.Close();
        this.GridView1.EditIndex = -1;
        band();
        //Response.Write("<script>alert('更新成功！')</script>");
    }

Answer 3

 if (!Page.IsPostBack) 
            startIndex = 0; 
        BindGrid(); 
================= if (!Page.IsPostBack) 
 {
        startIndex = 0; 
        BindGrid(); 
 }