页面更新问题~~
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class news_news_view : System.Web.UI.Page
{
SQLHelper sqlhelper = new SQLHelper();
DataSet dtnews = new DataSet();
DataSet dtreview = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (Request["id"] != null)
{
if (!IsPostBack)
{
sqlhelper.RunSQL("select * from Review where newsid='" + Request["id"] + "'", ref dtreview);
DataList1.DataSource = dtreview.Tables[0];
DataList1.DataKeyField = "reviewid";
DataList1.DataBind();
蓝色部分为从数据库表中读取数据并加入到datalist中
}
}
else
{
Response.Redirect("news_list.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e) 该单击事件为发表评论
{
SqlParameter[] prams ={
sqlhelper.CreateInParam("@reviewname",SqlDbType.NVarChar,50,reviewname.Text),
sqlhelper.CreateInParam("@reviewcontent",SqlDbType.NVarChar,100,reviewcontent.Text),
sqlhelper.CreateInParam("@reviewtime",SqlDbType.NVarChar,50,System.DateTime.Now.ToString()),
sqlhelper.CreateInParam("@newsid",SqlDbType.Int,50,Request["id"]),
sqlhelper.CreateInParam("@newstitle",SqlDbType.NVarChar,50,newstitle.Text)
};
sqlhelper.RunProc("ReviewInsert", prams);
红色部分为向数据库表中插入数据;
Page.ClientScript.RegisterStartupScript(GetType(), "MyScript", "<script>alert('评论成功!');</script>");
}
}
其他部分已经没问题了,就是在发表品论后(即执行单击事件)不能更新datalist中的数据。
谁会的帮个忙!
最好简单点的!