每次提交，为什么在数据库中出现了两篇相同文章（郁闷中…………）

amoo 2002-11-04 01:19:42

我做论坛使用了frame就是知道那里出问题了，打开datagrid的分页功能，点一次下一页出现一下跳过两页！

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if((int)(Page.Session["IsGood"])==0)
{
DisplayThd.NavigateUrl="display.aspx?subid="+Request.QueryString["subid"];
}
else
{
DisplayThd.NavigateUrl="jinghua.aspx?subid="+Request.QueryString["subid"];
};
strcon=ConfigurationSettings.AppSettings["eForum"];
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.cn = new System.Data.OleDb.OleDbConnection();
this.Button1.Click += new System.EventHandler(this.PostBtn_Click);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

protected void PostBtn_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
cn=new OleDbConnection(strcon);
cn.Open();
string strSQL="INSERT INTO Threads ([SubId],[Subject],[NickName],[SendTime],[Body],[Length])"+
" VALUES (@SubId,@Subject,@NickName,@SendTime,@Body,@Length)";
OleDbCommand cmd=new OleDbCommand(strSQL,cn);
cmd.Parameters.Add(new OleDbParameter ("@SubId",OleDbType.Integer,4));
cmd.Parameters["@SubId"].Value = Request.QueryString["subid"];

cmd.Parameters.Add(new OleDbParameter ("@Subject",OleDbType.VarChar,40));
cmd.Parameters["@Subject"].Value = Subject.Text;

cmd.Parameters.Add(new OleDbParameter ("@NickName",OleDbType.VarChar,20));
cmd.Parameters["@NickName"].Value =Page.Session["NickName"].ToString();

cmd.Parameters.Add(new OleDbParameter ("@SendTime",OleDbType.VarChar,20));
cmd.Parameters["@SendTime"].Value =DateTime.Now.ToString();

cmd.Parameters.Add(new OleDbParameter ("@Body",OleDbType.LongVarChar,65535));
cmd.Parameters["@Body"].Value = body.Text;

cmd.Parameters.Add(new OleDbParameter ("@Length",OleDbType.Integer,4));
cmd.Parameters["@Length"].Value = body.Text.ToString().Length;

cmd.ExecuteNonQuery();
cn.Close();
t1.Visible=false;
t2.Visible=false;
Response.Write(" <hr><center>");
Response.Write("<h2>恭喜！您的文章已经张贴到论坛中！<h2>");
if((int)(Session["IsGood"])==0)
{
Response.Write(" ");
Response.Write("<a href=display.aspx?subid="+Request.QueryString["subid"]+">");
Response.Write("返回普通区</a>");
Response.Write("</center><hr>");

}
else
{
Response.Write("");
Response.Write("<a href=jinghua.aspx?subid="+Request.QueryString["subid"]+">");
Response.Write("返回精华区</a>");
Response.Write("</center><hr>");
}
}
}

}
}

...全文