62,267
社区成员
发帖
与我相关
我的任务
分享
public partial class Admin_Default : System.Web.UI.Page
{
private bool mbRebind = false;
private string sConnectionString = ConfigurationManager.ConnectionStrings["blogConnString"].ToString();
protected void Page_PreRender(object sender, EventArgs e)
{
if (!IsCallback || mbRebind)
{
Bind();
}
}
private void Bind()
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("select * from wenzhang;select * from comment", conn);
da.Fill(ds);
}
ds.Relations.Add("relationsbetweenwenzhangandcomment", ds.Tables[0].Columns["blog_id"], ds.Tables[1].Columns["commentblog_id"]);
Repeater3.DataSource = ds;
Repeater3.DataBind();
}
protected void Repeater4_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "delcomment")
{
using (SqlConnection conn = new SqlConnection(sConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("delete from comment where comment_id=@commentid", conn))
{
cmd.Parameters.AddWithValue("@commentid", e.CommandArgument);
cmd.ExecuteNonQuery();
mbRebind = true;
}
}
}
}
}
if (!IsCallback )
{
Bind();
}
if (!IsPostBack)
{
Bind();
}
{
if (!IsPostback )// 是!IsPostback 而不是!IsCallback
{
Bind();
}
}