回复 9楼Alice的帖子
sql语句中,sqldatasource中日期的参数值是,Session["date"]。选中calendar日期时,会把所选中的日期存入Session["date"]中。
第一张图片是初始页面
第二张图片是calendar中日期变化后,出现的页面
这是附件
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- DBClass db = new DBClass();
- string sql_date = "select max(日期) from [produce1].[dbo].[nong_erfen]";
- string a = db.ExecScalar(sql_date).ToString();
-
- IFormatProvider culture = new CultureInfo("zh-CN", true);
- string[] expectedFormats = { "yyyyMMdd" };
- C1Calendar1.DisplayDate = DateTime.ParseExact(a, expectedFormats, culture, DateTimeStyles.AllowInnerWhite);
- C1Calendar1.SelectedDate = DateTime.ParseExact(a, expectedFormats, culture, DateTimeStyles.AllowInnerWhite);
- string s_date = string.Format("{0:yyyyMMdd}", C1Calendar1.SelectedDate);
- Session["date"] = s_date;
- }
- }
- protected void C1Calendar1_SelectedDatesChanged(object sender, EventArgs e)
- {
- string s_date = string.Format("{0:yyyyMMdd}", C1Calendar1.SelectedDate);
- Session["date"] = s_date;
- string date = Session["date"].ToString();
- DBClass db = new DBClass();
- string sql_nong_erfen = "SELECT [日期], [单位], [不良率时点], [不良率月增减], [不良率年增减], [不良金额时点], [不良金额月增减], [不良金额年增减] FROM [produce1].[dbo].[nong_erfen] where [日期]='" + date + "' ORDER BY [序号]";
- DataTable dt_nong_erfen = db.GetDataSet(sql_nong_erfen, "ok");
- this.SqlDataSource1.SelectParameters[0].DefaultValue = s_date;
-
- //如果执行以下两句,将会报错
- /*
- C1GridView1.DataSource = this.SqlDataSource1;
- C1GridView1.DataBind();*/
- }
- }
- }
复制代码 |