为什么更新不能用？

[zhanjiezj]

Page_Load内的代码注释掉时Button1单击时可以更新到数据库，但是当没有注释时Button1时就不会更新？
这问题真的很怪！

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            OleDbConnection acccon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("bfjDb/bfj.mdb").ToString());
            string Selectcmd = "select I_content from introduct where IID=" + 1;
            OleDbCommand acccomm = new OleDbCommand(Selectcmd, acccon);
            acccon.Open();
            OleDbDataReader reca = acccomm.ExecuteReader();
            string data="";
            while (reca.Read())
            {
                data = reca["I_content"].ToString();
            }
            Response.Write(data);
            reca.Close();
            acccon.Close();
        }
        catch (Exception ex)
        {
            Response.Write("<script language=JavaScript> alert('" + ex + "');</script>");
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //OleDbConnection acccon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("bfjDb/bfj.mdb").ToString());
        //string Updatecmd = "update introduct set I_content='" + FCKeditor1.Value + "' where IID="+1;
        //OleDbCommand acccomm = new OleDbCommand(Updatecmd, acccon);
        try
        {
            OleDbConnection acccon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("bfjDb/bfj.mdb").ToString());
            string Updatecmd = "update introduct set I_content='" + FCKeditor1.Value + "' where IID=" + 1;
            OleDbCommand acccomm = new OleDbCommand(Updatecmd, acccon);
            acccon.Open();
            acccomm.ExecuteNonQuery();
            acccon.Close();
            Response.Write("<script language=JavaScript> alert('发表成功!');</script>");
        }
        catch(Exception ex)
        {
            Response.Write("<script language=JavaScript> alert('"+ex+"');</script>");
        }
    }

[Haoze]

没看明白。

mark

[Aderlee]

加上试试

if(!IsPostBack)
{
 try
        {
            OleDbConnection acccon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("bfjDb/bfj.mdb").ToString());
            string Selectcmd = "select I_content from introduct where IID=" + 1;
            OleDbCommand acccomm = new OleDbCommand(Selectcmd, acccon);
            acccon.Open();
            OleDbDataReader reca = acccomm.ExecuteReader();
            string data="";
            while (reca.Read())
            {
                data = reca["I_content"].ToString();
            }
            Response.Write(data);
            reca.Close();
            acccon.Close();
        }
        catch (Exception ex)
        {
            Response.Write("<script language=JavaScript> alert('" + ex + "');</script>");
        }
}

[wzy_love_sly]

那可怪了

[amandag]

应该是没有做回传页的判断

2楼的代码即可解决问题

[zhanjiezj]

加上!IsPostBack的话，就不会有查询的效果了

[zhanjiezj]

加上!IsPostBack的话，就不会有查询的效果了

[amandag]

你应该把你查询的结果绑定到一个数据绑定控件上，而不是这样输出来

[zhanjiezj]

绑定到控件上？？？怎么绑定？？？