LISTVIEW+DataPage 动态加载数据源和分页处理

首先页面得有一个数据源控件和一个ListView控件，并且建立关联关系

 

我实现的是通过页面上的一个日历选中的日期来不断切换数据源，要还实现分布，而且刚进入页面时要先读入一个数据源。

 

这就需要一个标识，来纪录是点击了日历状态还是处在刚开始的显示状态。要用到Session变量，不然会很悲剧，直接上代码不解释 

 

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["cal"] = "false"; this.SqlDataSource1.SelectCommand = string.Format("SELECT [date], [content], [kind], [title], [author] FROM [news] ORDER BY date DESC "); } } protected void Calendar1_SelectionChanged(object sender, EventArgs e) { Session["cal"] = "true"; SqlDataSource1.ConnectionString = "server=.;database=edaily;integrated security=SSPI"; this.SqlDataSource1.SelectCommand = string.Format("SELECT [date], [content], [kind], [title], [author] FROM [news] where date='{0}'", this.Calendar1 .SelectedDate .ToShortDateString ()); SqlDataSource1.DataBind(); ListView1.DataBind(); } protected void ListView1_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e) { if (Session["cal"].Equals("true")) { SqlDataSource1.ConnectionString = "server=.;database=edaily;integrated security=SSPI"; this.SqlDataSource1.SelectCommand = string.Format("SELECT [date], [content], [kind], [title], [author] FROM [news] where date='{0}'", this.Calendar1.SelectedDate.ToShortDateString()); SqlDataSource1.DataBind(); ListView1.DataBind(); } else { SqlDataSource1.ConnectionString = "server=.;database=edaily;integrated security=SSPI"; this.SqlDataSource1.SelectCommand = string.Format("SELECT [date], [content], [kind], [title], [author] FROM [news] ORDER BY date DESC "); SqlDataSource1.DataBind(); ListView1.DataBind(); } }}