62,074
社区成员
发帖
与我相关
我的任务
分享
ParaOpra po = new ParaOpra();
Message ms = new Message();
//public string xianshi = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
this.AspNetPager1.RecordCount =po.PageSizes();//计算总记录数
this.ShowMsg();
this.AspNetPager1.CustomInfoHTML= "总记录数"+this.AspNetPager1.RecordCount.ToString();
this.AspNetPager1.CustomInfoHTML+=" "+"当前第"+AspNetPager1.CurrentPageIndex.ToString()+"页";
}
}
private void ShowMsg()
{
string ssql = "select * from companyMsg";
OleDbConnection conn = new OleDbConnection(OleDbHelper.ConnectionStringLocalTransaction);
OleDbDataAdapter da = new OleDbDataAdapter(ssql,conn);
DataTable dt = new DataTable();
da.Fill(dt);
int startIndex = this.AspNetPager1.StartRecordIndex;
StringBuilder sb = new StringBuilder();
sb.Append("<table width=\"500\" style=\"margin-left:50px;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
DataRow row;
if (AspNetPager1.RecordCount == 0)
{
sb.Append("<tr><td>现在暂时没有留言</td></tr>");
}
else
{
while (startIndex <= this.AspNetPager1.EndRecordIndex)
{
row = dt.Rows[startIndex - 1];
sb.Append("<tr><td width=\"50\" style=\"text-align:right\">" + "标题:" + "</td><td>" + row["MsgTitle"] + " " + " 时间:" + row["MsgTime"] + "</td></tr>");
sb.Append("<tr><td width=\"50\" style=\"text-align:right\">内容:</td><td>" + row["MsgContent"] + "</td></tr>");
startIndex++;
}
}
sb.Append("</table>");
this.PlaceHolder1.Controls.Add(new LiteralControl(sb.ToString()));
}
protected void Submit_Click(object sender, EventArgs e)
{
ms.MsgTitle = this.msgtitle.Text;
ms.MsgTime = DateTime.Now.ToString();
ms.MsgContent = this.msgcontent.Text;
ms.MsgUserIP = HttpContext.Current.Request.UserHostAddress;
po.CusMsg(ms);
if(po.CusMsg(ms)>0)
{
this.ShowMsg();
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert1", "<script>alert('留言成功!');</script>");
}
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
this.ShowMsg();
}
ParaOpra po = new ParaOpra();
Message ms = new Message();
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
this.AspNetPager1.RecordCount = po.PageSizes();
this.AspNetPager1.CustomInfoHTML = "总记录数" + this.AspNetPager1.RecordCount.ToString();
this.AspNetPager1.CustomInfoHTML += " " + "当前第" + AspNetPager1.CurrentPageIndex.ToString() + "页";
this.AspNetPager1.DataBind();
this.ShowMsg();
}
}
private void ShowMsg()
{
string ssql = "select * from companyMsg order by id desc";
OleDbConnection conn = new OleDbConnection(OleDbHelper.ConnectionStringLocalTransaction);
OleDbDataAdapter da = new OleDbDataAdapter(ssql,conn);
DataTable dt = new DataTable();
da.Fill(dt);
int startIndex = this.AspNetPager1.StartRecordIndex;
StringBuilder sb = new StringBuilder();
sb.Append("<table width=\"500\" style=\"margin-left:50px;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
DataRow row;
if (AspNetPager1.RecordCount == 0)
{
sb.Append("<tr><td>现在暂时没有留言</td></tr>");
}
else
{
while (startIndex <= this.AspNetPager1.EndRecordIndex)
{
row = dt.Rows[startIndex - 1];
sb.Append("<tr><td width=\"50\" style=\"text-align:right\">" + "标题:" + "</td><td>" + row["MsgTitle"] + " " + " 时间:" + row["MsgTime"] + "</td></tr>");
sb.Append("<tr><td width=\"50\" style=\"text-align:right\">内容:</td><td>" + row["MsgContent"] + "</td></tr>");
startIndex++;
}
}
sb.Append("</table>");
this.PlaceHolder1.Controls.Add(new LiteralControl(sb.ToString()));
}
protected void Submit_Click(object sender, EventArgs e)
{
ms.MsgTitle = this.msgtitle.Text;
ms.MsgTime = DateTime.Now.ToString();
ms.MsgContent = this.msgcontent.Text;
ms.MsgUserIP = HttpContext.Current.Request.UserHostAddress;
if(po.CusMsg(ms)>0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert1", "<script>alert('留言成功!');</script>");
this.ShowMsg();
}
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
this.ShowMsg();
}
ParaOpra po = new ParaOpra();
Message ms = new Message();
//public string xianshi = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
DataBind() ;
}
}
private void DataBind()
{
string ssql = "select * from companyMsg";//这里做点修改,可以用一个存储过程什么的,根据this.AspNetPager1.CurrentPageIndex和,this.AspNetPager1.PageSize来查出所需要的数据
OleDbConnection conn = new OleDbConnection(OleDbHelper.ConnectionStringLocalTransaction);
OleDbDataAdapter da = new OleDbDataAdapter(ssql,conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.AspNetPager1.RecordCount =dt.Rows.Count;
this.AspNetPager1.DataBind();
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
DataBind();
}