62,040
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
//主函数
public void Bind()
{
try
{
string keyword = Request.Form["keyword"].Trim();
string sql = "select * from news Where titles like '%"+keyword+"%' order by id Desc";
IList<Vaisi_newslistModel> list = new List<Vaisi_newslistModel>();
DataTable table = SqlHelper.GetScalarListTable(sql);
foreach (DataRow row in table.Rows)
{
Vaisi_newslistModel news = new Vaisi_newslistModel();
news.Id = Convert.ToInt32(row["id"]);
news.Titles = Convert.ToString(row["titles"]);
news.Img_url = Convert.ToString(row["img_url"]);
news.Dtime = DateTime.Parse(row["dtime"].ToString());
news.Contents = Convert.ToString(row["contents"]);
list.Add(news);
}
this.GridView1.DataSource = list;
this.GridView1.DataBind();
}
catch (Exception)
{
}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
GridView gvw = (GridView)sender;
if (e.NewPageIndex < 0)
{
System.Web.UI.WebControls.TextBox pageNum = (System.Web.UI.WebControls.TextBox)gvw.BottomPagerRow.FindControl("tbPage");
int pa = int.Parse(pageNum.Text);
if (pa <= 0)
gvw.PageIndex = 0;
else
gvw.PageIndex = pa - 1;
}
else
{
gvw.PageIndex = e.NewPageIndex;
}
Bind();
}
catch (Exception)
{
}
}
<form id="Form1" runat="server">
<ul>
<asp:GridView ID="GridView1" runat="server" Width="95%" BorderWidth="0px" DataKeyNames="id" OnPageIndexChanging="GridView1_PageIndexChanging" AutoGenerateColumns="False" AllowPaging="true" PageSize="1">
<Columns>
<asp:TemplateField HeaderText="新闻标题">
<ItemTemplate>
<a href="../Show.aspx?Newsid=<%# Eval("id") %>"><%# Eval("Titles") %></a>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="发布时间" HeaderStyle-CssClass="th_time" ItemStyle-CssClass="td_time">
<ItemTemplate><%# Eval("dtime")%></ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="操作" HeaderStyle-CssClass="th_category">
<ItemTemplate>
<a href="../Show.aspx?Newsid=<%# Eval("id") %>">浏览</a> <a href="News_Modify.aspx?Newsid=<%# Eval("id") %>">修改</a>
<asp:LinkButton ID="LName" runat="server" PostBackUrl='<%# Eval("id", "News_Del.aspx?id={0}") %>' Text='删除'></asp:LinkButton>
</ItemTemplate>
<HeaderStyle CssClass="th_category"></HeaderStyle>
</asp:TemplateField>
</Columns>
<PagerTemplate>
<center style="color: Gray;margin-top:30px;">
<asp:LinkButton ID="lbFirst" runat="server" CausesValidation="False" CommandArgument="First"
ForeColor="Gray" CommandName="Page" CssClass="pagecss"><font color="white">首页</font></asp:LinkButton>
<asp:LinkButton ID="lbPrev" runat="server" CausesValidation="False" CommandArgument="Prev"
ForeColor="Gray" CommandName="Page" CssClass="pagecss"><font color="white">上一页</font></asp:LinkButton>
<asp:LinkButton ID="lbNext" runat="server" CausesValidation="False" CommandArgument="Next"
ForeColor="Gray" CommandName="Page" CssClass="pagecss"><font color="white">下一页</font></asp:LinkButton>
<asp:LinkButton ID="lbLast" runat="server" CausesValidation="False" CommandArgument="Last"
ForeColor="Gray" CommandName="Page" CssClass="pagecss"><font color="white">尾页</font></asp:LinkButton>
第<asp:Label ID="Label2" runat="server" CssClass="pagecss" Text="<%#((GridView)Container.Parent.Parent).PageIndex + 1 %>"></asp:Label>页
共<asp:Label ID="Label1" runat="server" CssClass="pagecss" Text="<%# ((GridView)Container.Parent.Parent).PageCount %>"></asp:Label>页
</center>
</PagerTemplate>
</asp:GridView>
</ul>
</form>