我做了一个页面，是更新用的，我把数据库的内容用DataSet取出来，然后用update语句更新，为什么没反应，还是原来数据库的内容，请问用什么方法可以更新。代码如下：
SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection("Server=.;uid=sa;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select uname,age from test1 where uid='"+5+"'",con);
DataSet ds = new DataSet();
da.Fill(ds);
TextBox2.Text = ds.Tables[0].Rows[0][0].ToString();
TextBox3.Text = ds.Tables[0].Rows[0][1].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
string Sql = "update test1 set uname='"+TextBox2.Text+"',age='"+TextBox3.Text+"'";
SqlCommand cmd = new SqlCommand(Sql, con);
cmd.ExecuteNonQuery();
con.Close();
}

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
con = new SqlConnection("Server=.;uid=sa;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select uname,age from test1 where uid='"+5+"'",con);
DataSet ds = new DataSet();
da.Fill(ds);
TextBox2.Text = ds.Tables[0].Rows[0][0].ToString();
TextBox3.Text = ds.Tables[0].Rows[0][1].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
string Sql = "update test1 set uname='"+TextBox2.Text+"',age='"+TextBox3.Text+"'";
SqlCommand cmd = new SqlCommand(Sql, con);
cmd.ExecuteNonQuery();
con.Close();
}

在Page_Load事件里很容易疏忽对IsPostBack的判断