文件名称:asp.net基于XML的留言板
文件大小:1.93MB
文件格式:RAR
更新时间:2015-10-16 17:22:38
asp.net xml 留言板
asp.net基于XML的留言板 代码片段: protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.dlBind(); } } public void dlBind() { int curpage = Convert.ToInt32(labNowPage.Text); PagedDataSource ps = new PagedDataSource(); SqlConnection mycon = new SqlConnection(ConfigurationManager.AppSettings["ConSQL"]); mycon.Open(); string cmdtxt2 = "SELECT * FROM tb_Reply WHERE ReplyID='" + Request["ID"].ToString() + "'"; SqlDataAdapter MyAdapter = new SqlDataAdapter(cmdtxt2, mycon); DataSet ds = new DataSet(); MyAdapter.Fill(ds, "tb_Reply"); ps.DataSource = ds.Tables["tb_Reply"].DefaultView; ps.AllowPaging = true; //是否可以分页 ps.PageSize = 4; //显示的数量 ps.CurrentPageIndex = curpage - 1; //取得当前页的页码 lnkbtnPrve.Enabled = true; lnkbtnTop.Enabled = true; lnkbtnNext.Enabled = true; lnkbtnLast.Enabled = true; if (curpage == 1) { lnkbtnTop.Enabled = false;//不显示第一页按钮 lnkbtnPrve.Enabled = false;//不显示上一页按钮 } if (curpage == ps.PageCount) { lnkbtnNext.Enabled = false;//不显示下一页 lnkbtnLast.Enabled = false;//不显示最后一页 } this.labCount.Text = Convert.ToString(ps.PageCount); this.DataList1.DataSource = ps; this.DataList1.DataKeyField = "ID"; this.DataList1.DataBind(); } protected void lnkbtnTop_Click(object sender, EventArgs e) { this.labNowPage.Text = "1"; this.dlBind(); } protected void lnkbtnPrve_Click(object sender, EventArgs e) { this.labNowPage.Text = Convert.ToString(Convert.ToInt32(this.labNowPage.Text) - 1); this.dlBind(); } protected void lnkbtnNext_Click(object sender, EventArgs e) { this.labNowPage.Text = Convert.ToString(Convert.ToInt32(this.labNowPage.Text) + 1); this.dlBind(); } protected void lnkbtnLast_Click(object sender, EventArgs e) { this.labNowPage.Text = this.labCount.Text; this.dlBind(); } protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) { string strid = this.DataList1.DataKeys[e.Item.ItemIndex].ToString(); //获取当前DataList控件列 string com = "Delete from tb_Reply where ID='" + Convert.ToInt32(strid) + "'"; SqlData da = new SqlData(); da.ExceSQL(com); Page.Response.Redirect("LeaveWordView.aspx?ID="+Request["ID"].ToString()+""); }